[GRASS-user] v.color with layer 2
neteler at osgeo.org
Thu Mar 19 05:18:37 EDT 2009
On Thu, Mar 19, 2009 at 8:58 AM, Paolo Craveri <pcraveri at gmail.com> wrote:
> Hi to all
> I have some problems with v.colors (grass6.5.svn) when I try to use it
> with a vector on layer 2; I get this error:
> DBMI-SQLite driver error:
> Error in sqlite3_prepare():
> near "mypoints2_2": syntax error
> ERROR: Error while executing: 'UPDATE mypoints2
> mypoints2_2 SET GRASSRGB = '0:0:255' WHERE cat = 1'
> ERROR: Processing SQL transaction
> Here a little script that reproduces this error:
Great - like this it was easy to reproduce here.
> # # spearfish60 dataset
> db.connect database='$GISDBASE/$LOCATION_NAME/$MAPSET/mydbsqlite' driver=sqlite
> g.copy vect=archsites,mypoints --overwrite
> v.category in=mypoints layer=2 out=mypoints2 opt=add --overwrite
> v.db.addtable mypoints2 layer=2
> v.colors map=mypoints2 layer=2 color=bcyr column=cat
> Where I'm wrong?
You aren't. It was a bug which I have now fixed:
(also in the other branches).
Thanks for catching it,
More information about the grass-user