[GRASSLIST:3749] Re: db.execute

[Radim Blazek]

On Friday 25 June 2004 17:43, Daniel Isenegger wrote:
> Hi
> i'm working on a suse 8.2 with grass57 (compiled from source) on a local
> Grass-DB:
>
> with:
> db.connect -p
> driver:dbf
> database:/data/gis/nfp48/nfp48/ipodlas0.1/grass/grassdata/UpperEngadine/dis
>en/dbf
>
> db.select-statement works well
> (echo "select defoliatio from defoliation_53_shp" | db.select)
>
> but db.execute statements fail, e.g.:
> echo 'create table test_table ("cat" int, "desc" text)' | db.execute

'text' is not supported by DBF, column names should not be quoted, try
echo 'create table test_table (cat int, desc varchar(50))' | db.execute

> also db.driver fails with the error:
> error: can't read "opttype(1)": no such element in array

db.drivers -p ? Command line or GUI? 

Radim