[GRASS-dev] Re: [GRASS-user] SQL Error using "v.color"

Roy:

> To follow up on your earlier comment, submitting:
> v.db.connect -g map=pse layer=1 fs=";"
> yields:
> 1/pse;pse;cat;C://test/poverty/sqlite.db;sqlite
> Does this help?

Hamish:

yes. for some reason on windows the sqlite table is given a name, and
that gets reported along with the layer number (1/name;...). So trying
to match against just the number fails. I wasn't aware of that
name being set by anything yet, although support for it has been there
for a long time. (?) shrug, "v.db.connect layer=1 -g -l" should avoid
the grep now, so just a curiosity.

these scripts will probably also need the -l flag instead of the grep:

d.vect.thematic
v.db.addcol
v.db.addtable
v.db.dropcol
v.db.droptable
v.db.join
v.db.renamecol
v.db.update
v.dissolve
v.out.gpsbabel
v.rast.stats
v.report

and we should check python scripts/libs for anything that uses
v.db.connect too as the parsing could be broken there too.

Hamish