[GRASS-user] database(s) in grass

[Ricardo Oliveira]

Dear users,
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: 
============================================
D0/0: Name = cat
D0/0: Name = _grass_internal_database_encoding
D0/0: Name = _grass_internal_database_encoding
Could not set Tcl system encoding to 
D0/0: Name = _grass_internal_database_encoding
Could not set Tcl system encoding to 
D0/0: Name = _grass_internal_database_encoding
Could not set Tcl system encoding to 
DBMI-SQLite driver error:
Error in sqlite3_prepare():
near "where": syntax error


Cannot update table
============================================

I am using the sqlite driver, and i have used the following commands to build and connect to my database:
sqlite3 basedados.db
create table name (id varchar(10), cat smallint, feature smallint);
EOF
db.connect driver=sqlite database="basedados.db"
db.connect -p

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...) ?

Tips are needed for the error and for my questions...
Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20070411/5885a2fa/attachment.html