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

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

Reply via email to