[GRASS5] db.execute

[Stephan Holl]

Dear List,

I have problems to insert new rows in a newly created attribute-table.
my given command:

echo "INSERT INTO laender ( id, cat ) VALUES('86', 'YY')"|db.execute
DBMI-DBF driver error:
Incompatible value type.
Error in db_execute_immediate()

ERROR: Error while executing: "INSERT INTO laender ( id, cat )
VALUES('86',       'YY')
       "
But I  have no success, the dbf-attribute-table stays empty.

The table:
db.describe laender
table:laender
description:
insert:yes
delete:yes
ncols:2

column:id
description:
type:INTEGER
len:11
scale:0
precision:10
default:0
nullok:yes
select:yes
update:yes

column:cat
description:
type:CHARACTER
len:59
scale:0
precision:0
default:
nullok:yes
select:yes
update:yes

Can anybody give me a hint to solve this problem, please?

Thanks in advance

Cheers
	Stephan

-- 
Stephan Holl

Check headers for GnuPG Key!
http://www.gdf-hannover.de

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/grass-dev/attachments/20050127/6b7c6412/attachment.bin