[GRASS-user] Connecting Vectors to Attribute Tables

[Micha Silver]

Andrew Lewin wrote:

> Dear All,
>
> I am having some difficulty viewing an attribute table from a vector 
> file that is connected to a sqlite database table.
>
> Here is the terminal snippet of my commands with errors:
>
> GRASS 6.4.0RC5 (SantaMonicaBayMM):~ > v.in.db driver=sqlite 
> database=/USers/andrewlewin/MM_SMB.db table=MMSightings1 x=LONG y=LAT 
> key=cat out=MMSightings_layer2Writing features...
>  100%
> Copying attributes...
> DBMI-SQLite driver error:
> Cannot scan date:"Date"
>
....
Is there a column named "Date". Maybe because it's an sqlite reserved 
word, importing the table fails.