<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7650.28">
<TITLE>database(s) in grass</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Dear users,<BR>
Being a recent GRASS user i am facing some problems with databases: i am using v.digit and after finishing a boundary i get the following error:<BR>
============================================<BR>
D0/0: Name = cat<BR>
D0/0: Name = _grass_internal_database_encoding<BR>
D0/0: Name = _grass_internal_database_encoding<BR>
Could not set Tcl system encoding to<BR>
D0/0: Name = _grass_internal_database_encoding<BR>
Could not set Tcl system encoding to<BR>
D0/0: Name = _grass_internal_database_encoding<BR>
Could not set Tcl system encoding to<BR>
DBMI-SQLite driver error:<BR>
Error in sqlite3_prepare():<BR>
near "where": syntax error<BR>
<BR>
<BR>
Cannot update table<BR>
============================================<BR>
<BR>
I am using the sqlite driver, and i have used the following commands to build and connect to my database:<BR>
sqlite3 basedados.db<BR>
create table name (id varchar(10), cat smallint, feature smallint);<BR>
EOF<BR>
db.connect driver=sqlite database="basedados.db"<BR>
db.connect -p<BR>
<BR>
I am a complete newby in terms of databases...when browsing my table with sqlitebrowser i am able to find IDs on the table i have created inside v.digit, (1,2,3...) these IDs are related to the entities i digitized i assume...but shouldn`t the coordinates have their column on this database too (at least for the centroid...) ?<BR>
<BR>
Tips are needed for the error and for my questions...<BR>
Thanks</FONT>
</P>
</BODY>
</HTML>