Re: PB 6.0, Informix SE, and Serial Columns

In article <35c1cdcf.8581811@n3.idirect.com>, Rajendra Singh wrote: >I have an application which inserts rows into a table that has a serial column. >How do I determine the (serial) value of the last row I inserted? > Look in the Online Help at "INFORMIX database interface, INSERT": Row serial number The serial number of the row is stored in the SQLReturnData property of the transaction object after an INSERT statement executes. (The SQLReturnData property is updated after embedded SQL only; it is not updated after a DataWindow operation.) If you fill the serial column with 0 before the INSERT Statement it works automatically with DataWindow's. Regards Martin ---------------------------------------------------------------------------- Dipl.-Inform. (FH) Martin Stockinger mstockin@forwiss.uni-passau.de FORWISS Passau Innstr. 33 Tel.: +49-(0)-8504/400-192 D-94032 Passau Fax : +49-(0)-89/66617-22968