How to retrieve the serial value for a new inserted row?

How to retrieve the serial value for a new inserted row?

Post by Rios Frankli » Fri, 22 Feb 2002 02:23:11



I am running INFORMIX ONLINE 5.02  and I haven't the function or
procedure DBINFO.

Thanks for your help  

Franklin Rios

:-)

 
 
 

How to retrieve the serial value for a new inserted row?

Post by Jonathan Leffle » Fri, 22 Feb 2002 14:57:39



> I am running INFORMIX ONLINE 5.02  and I haven't the function or
> procedure DBINFO.

> Thanks for your help

> Franklin Rios

> :-)

Upgrade - to 5.10 or later.  Do the upgrade before you need to do a
recovery from your backups.  5.02 is not Y2K compliant.

I'm not sure whether DBINFO is in the 5.1x servers, so it may not
resolve that problem.  But do the upgrade anyway - or, at the very
least, verify that you really can recover from your archives *before*
you need to do it under stress because of an actual system failure.

--

Guardian of DBD::Informix 1.00.PC2 -- see http://dbi.perl.org/
#include <disclaimer.h>

 
 
 

1. How to retrieve the serial value for a new inserted row

Hi,

I need to retrieve the value for a column with serial data type when I
insert a new row using VisualBasic and ODBC connection.

In 4GL I can use the SQLCA record, but how I can do the same using
VisualBasic an ODBC?

I'm running Informix Online 5.02 and Informix Star on a SCO box.

Thanks for your help

Manuel Ortiz
:-)

2. VFP question - Index ReCreation and Persistent Relations

3. Retrieving correct SERIAL number of new row

4. ODBC Success Stories

5. retrieving the serial values after insert

6. Crystal - using 2 tables in 1 report???

7. retrieve a serial value after an insert via stored procedure

8. Chef de projet Sybase (suite)

9. SERIAL field value of last inserted row

10. DBI/DBD-informix, value of a new serial after insert

11. How to retrieve the IDENTITY (Counter) value of INSERTed rows