<HTML>
<HEAD>
<TITLE>Questions about v.to.db and table update from v.digit</TITLE>
</HEAD>
<BODY>
<FONT FACE="Skia, Verdana, Helvetica, Arial"><SPAN DEFANGED_STYLE='font-size:12.0px'>I’ve run into a couple of items that I hope someone can clarify.<BR>
<BR>
1st v.to.db: What does query mode do and how does it work? There is no explanation for this in docs. I’ve tried various trial and error (clearly all error so far) and I can’t get anything to give any results using query mode. Also, there is a suggestion that you can list multiple columns for the col argument, but this produces an error. Is this not implemented yet or is my syntax wrong (column,column,...)<BR>
<BR>
2nd table update in v.digit: Sometimes it works and sometimes it doesn’t. I made a table to go along with the Spearfish streams vector file (after giving unique cat values to each stream segment). I can query it and update values with v.to.db. I tried to change a value in v.digit and I consistently received the following error when I try to replace 0 with 2 in the order column.<BR>
<BR>
</SPAN></FONT><SPAN DEFANGED_STYLE='font-size:12.0px'><FONT FACE="Arial">Cannot update table:<BR>
DBMI-DBF driver error:<BR>
SQL parser error in statement:<BR>
update streams set ORDER = 2, LENGTH = 3488.474000 where cat = 21<BR>
Error in db_execute_immediate()<BR>
<BR>
Thanks for any clarification.<BR>
<BR>
Michael<BR>
</FONT><FONT FACE="Skia, Verdana, Helvetica, Arial">____________________<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>