[GRASS-user] v.digit cannot update table

Hi,

In GRASS CVS, I'm encountering problems digitizing into a vector with the
following:

v.digit -n map=newvect bg="d.vect coastline"

Clicking on the settings button -> table tab -> "create table" tells me
that a new empty map has been created. I then proceed with the "digitize
new boundary" button and create a polygon. When right-clicking to close
the line I'm asked about what encoding to use (I leave it as utf-8 which
which is my locale) and then "submit", I receive the following error:

---<---------------cut here---------------start-------------->---
DBMI-DBF driver error:
SQL parser error:
in statement:
update newvect set where cat = 1
Error in db_execute_immediate()

WARNING: Cannot update table
---<---------------cut here---------------end---------------->---

and on exit:

Building topology ...
1 primitives registered
Building areas: 100%
0 areas built
0 isles built
Attaching islands:
Attaching centroids: 100%
Topology was built.
Number of nodes : 2
Number of primitives: 1
Number of points : 0
Number of lines : 0
Number of boundaries: 1
Number of centroids : 0
Number of areas : 0
Number of isles : 0
Number of incorrect boundaries : 1

Any ideas what might be wrong? Thanks.

Cheers,

--
Seb

Seb wrote:

Hi,

In GRASS CVS, I'm encountering problems digitizing into a vector with the
following:

v.digit -n map=newvect bg="d.vect coastline"

Clicking on the settings button -> table tab -> "create table" tells me
that a new empty map has been created. I then proceed with the "digitize
new boundary" button and create a polygon. When right-clicking to close
the line I'm asked about what encoding to use (I leave it as utf-8 which
which is my locale) and then "submit", I receive the following error:

---<---------------cut here---------------start-------------->---
DBMI-DBF driver error:
SQL parser error:
in statement:
update newvect set where cat = 1
Error in db_execute_immediate()

WARNING: Cannot update table
---<---------------cut here---------------end---------------->---

and on exit:

Building topology ...
1 primitives registered
Building areas: 100%
0 areas built
0 isles built
Attaching islands:
Attaching centroids: 100%
Topology was built.
Number of nodes : 2
Number of primitives: 1
Number of points : 0
Number of lines : 0
Number of boundaries: 1
Number of centroids : 0
Number of areas : 0
Number of isles : 0
Number of incorrect boundaries : 1

Any ideas what might be wrong? Thanks.

Can you try it with:

  export DEBUG=3
  v.digit -n map=newvect bg="d.vect coastline"

?

--
Glynn Clements <glynn@gclements.plus.com>

On Sat, 21 Apr 2007 20:50:19 +0100,
Glynn Clements <glynn@gclements.plus.com> wrote:

[...]

Can you try it with:

  export DEBUG=3

Yes, I tried it with that, but I don't see more messages. Here's the
output after trying to draw a square:

---<---------------cut here---------------start-------------->---
v.digit -n map=newvect bg="d.vect coastline"
New empty map created.
PNG: GRASS_TRUECOLOR status: TRUE
PNG: collecting to file:
/home/sluque/GRASSDATA/Coast_geo/sluque/.tmp/patagonia/18803.0.ppm,
GRASS_WIDTH=642, GRASS_HEIGHT=289

cat integer
PNG: GRASS_TRUECOLOR status: TRUE
PNG: collecting to file:
/home/sluque/GRASSDATA/Coast_geo/sluque/.tmp/patagonia/18803.1.ppm,
GRASS_WIDTH=642, GRASS_HEIGHT=289
DBMI-DBF driver error:
SQL parser error:
in statement:
update newvect set where cat = 1
Error in db_execute_immediate()

WARNING: Cannot update table
Building topology ...
1 primitives registered
Building areas: 100%
0 areas built
0 isles built
Attaching islands:
Attaching centroids: 100%
Topology was built.
Number of nodes : 2
Number of primitives: 1
Number of points : 0
Number of lines : 0
Number of boundaries: 1
Number of centroids : 0
Number of areas : 0
Number of isles : 0
---<---------------cut here---------------end---------------->---

--
Seb

Seb wrote:

On Sat, 21 Apr 2007 20:50:19 +0100,
Glynn Clements <glynn@gclements.plus.com> wrote:

[...]

> Can you try it with:

> export DEBUG=3

Yes, I tried it with that, but I don't see more messages. Here's the
output after trying to draw a square:

---<---------------cut here---------------start-------------->---
v.digit -n map=newvect bg="d.vect coastline"
New empty map created.
PNG: GRASS_TRUECOLOR status: TRUE
PNG: collecting to file:
/home/sluque/GRASSDATA/Coast_geo/sluque/.tmp/patagonia/18803.0.ppm,
GRASS_WIDTH=642, GRASS_HEIGHT=289

Are you running it from gis.m?

Try running it from the terminal, after "export DEBUG=3".

--
Glynn Clements <glynn@gclements.plus.com>

On Sat, 21 Apr 2007 14:33:50 -0500,
Seb <spluque@gmail.com> wrote:

Hi, In GRASS CVS, I'm encountering problems digitizing into a vector
with the following:

v.digit -n map=newvect bg="d.vect coastline"

Clicking on the settings button -> table tab -> "create table" tells me
that a new empty map has been created. I then proceed with the
"digitize new boundary" button and create a polygon. When
right-clicking to close the line I'm asked about what encoding to use (I
leave it as utf-8 which which is my locale) and then "submit", I receive
the following error:

The cause of this error was that the table needs to have more than the
'cat' column. I was simply creating the table without adding an extra
column because I don't need any attributes.

--
Seb