[GRASS5] Why can't I update table in d.what.vect?

[Michael Barton]

I am trying to enhance the Spearfish dataset with attribute values to use in
a class.

I divided the stream vector into its component segements and made a
attribute table for streams with an entry for each stream segment. It is
linked by a corresponding cat value key field. It looks fine in all ways of
checking how this is linked. I¹d like to put values in the table.

I can use v.to.db to put in the lengths of each segment, I can use Open
Office to manually enter values for each segment, I can use the new
v.db.updatecol script to put values in the attribute table. But if I try to
do it with d.what.vect or v.digit, I get the following error

Cannot update table:
DBMI_DBF driver error:
SQL parser error in statement:
update streams set LABEL = 'no name',
ORDER = 0, LENGTH = 3640.424000, name
= 'Miller Creek' where cat = 26
Error in db_execute_immediate()

After I was unable to update label, I made another column ³name² using
v.db.addcolumn. Again no problem, but I still can¹t update it using
d.what.vect. I¹ve checked the file permissions and they are fine. I¹m
working in the same (PERMANENT) mapset as the file.

On the other hand, I also added extra columns to archsites and roads and CAN
update their tables via d.what.vect.

Any idea what¹s wrong here?

Michael

____________________
C. Michael Barton, Professor of Anthropology
School of Human Evolution and Social Change
PO Box 872402
Arizona State University
Tempe, AZ  85287-2402
USA

Phone: 480-965-6262
Fax: 480-965-7671
www: <www.public.asu.edu/~cmbarton>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-dev/attachments/20050601/4e3f86c6/attachment.html