Re: Reading a Row That was Just Inserted

=================================================== ============= > ===== > But we also face a problem reading contents of a serial value when > the row has been just inserted. We are using Intersolv Q+E ODBC driver > for informix 5 at the client end . We do not use ESQL/C . Our programs > are in MSVC > . > To get the value of the serial feild we use a select statement to get the > max value. > But this is not the correct solution since any other client can in the mean > time > inset a new row . For this we have to lock the table. Locking is what we > dread . > We do not want to restrict any other user from entring new records. > > does anyone have any solution > thanks > amit This may be specific to the Informix driver, but we use GetStmtOption(HTMT,1048,&iRowid) to get the rowid and GetStmtOption(HTMT,1049,&iSerial) to get serial value We also use the Intersolv ODBC driver with I-NET Good Luck