[GRASS5] db.execute

GRASS GIS GRASS GIS developer
1

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

2

Because the id field is an integer it doesn't require single quotes:

echo "INSERT INTO laender ( id, cat ) VALUES(86, 'YY')"|db.execute

Yours,
Forrest R. Stevens

-----Original Message-----
From: grass5-admin@grass.itc.it [mailto:grass5-admin@grass.itc.it] On
Behalf Of Stephan Holl
Sent: Thursday, January 27, 2005 9:11 AM
To: grass5@grass.itc.it
Subject: [GRASS5] db.execute

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

3

Hello grass@forreststevens.com,

On Thu, 27 Jan 2005 09:22:49 -0700 <grass@forreststevens.com> wrote:

Because the id field is an integer it doesn't require single quotes:

echo "INSERT INTO laender ( id, cat ) VALUES(86, 'YY')"|db.execute

Thank you... I was blind when setting up the insert-statement. Now it
works like a charme..

Cheers
  Stephan

--
Stephan Holl

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