<HTML>
<HEAD>
<TITLE>Why can't I update table in d.what.vect?</TITLE>
</HEAD>
<BODY>
<FONT FACE="Skia, Verdana, Helvetica, Arial"><SPAN DEFANGED_STYLE='font-size:12.0px'>I am trying to enhance the Spearfish dataset with attribute values to use in a class.<BR>
<BR>
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.<BR>
<BR>
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<BR>
<BR>
</SPAN></FONT><SPAN DEFANGED_STYLE='font-size:12.0px'><FONT FACE="Helvetica, Verdana, Arial">Cannot update table:<BR>
DBMI_DBF driver error:<BR>
SQL parser error in statement:<BR>
update streams set LABEL = 'no name',<BR>
ORDER = 0, LENGTH = 3640.424000, name<BR>
= 'Miller Creek' where cat = 26<BR>
Error in db_execute_immediate()<BR>
</FONT><FONT FACE="Skia, Verdana, Helvetica, Arial"><BR>
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.<BR>
<BR>
On the other hand, I also added extra columns to archsites and roads and CAN update their tables via d.what.vect.<BR>
<BR>
Any idea what’s wrong here?<BR>
<BR>
Michael<BR>
<BR>
____________________<BR>
C. Michael Barton, Professor of Anthropology<BR>
School of Human Evolution and Social Change<BR>
PO Box 872402<BR>
Arizona State University<BR>
Tempe, AZ 85287-2402<BR>
USA<BR>
<BR>
Phone: 480-965-6262<BR>
Fax: 480-965-7671<BR>
www: <www.public.asu.edu/~cmbarton><BR>
</FONT></SPAN>
</BODY>
</HTML>