Informix and iBatis, my specialist subject.
in your selectKey statement use this sql:
select dbinfo('sqlca.sqlerrd1') from systables where tabname='systables'
That should get you the number generated from a serial column in your last insert.
Gaz.
----- Original Message ----
From: D. Richter <[EMAIL PROTECTED]>
To: [email protected]
Sent: Thursday, 11 May, 2006 1:44:15 PM
Subject: Auto-Generated Keys in Informix
in your selectKey statement use this sql:
select dbinfo('sqlca.sqlerrd1') from systables where tabname='systables'
That should get you the number generated from a serial column in your last insert.
Gaz.
----- Original Message ----
From: D. Richter <[EMAIL PROTECTED]>
To: [email protected]
Sent: Thursday, 11 May, 2006 1:44:15 PM
Subject: Auto-Generated Keys in Informix
Hi,
is there any possibility to get the auto-generated key
from the INSERT-Statement in an Informix-DB with the
selectKey-Element?
Dennis
--
GMX Produkte empfehlen und ganz einfach Geld verdienen!
Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner
is there any possibility to get the auto-generated key
from the INSERT-Statement in an Informix-DB with the
selectKey-Element?
Dennis
--
GMX Produkte empfehlen und ganz einfach Geld verdienen!
Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner
