Serial Value with OLEDB and INFORMIX 9.12
Posted in 1998
I am using INTERSOLV DataDirect OLEDB connecting to INFORMIX 9.12 I would like to get the serial value after a insert statement w/o using a stored proc. I know about dbinfo... I would like to avoid using a Recordset and just issue a insert statement but I don't know what property the serial gets assigned to. Examples: DataSource = "Provider=INTERSOLV Informix9 OLE DB Provider;Data Source=Informix9;User ID=unm;Password=pwd" Set adoConn = CreateObject("ADODB.Connection") adoConn.Open DataSource Set adoRS = CreateObject("ADODB.Recordset") SqlString = "insert into someTable (id, name) values (0,'test');" adoRS.Open SqlString, adoConn ' What Now??? Empty Recordset. OR SqlString = "insert into someTable (id, name) values (0,'test');" Set adoConn = CreateObject("ADODB.Connection") adoConn.execute SqlString, DataSource ' What Now???