ADO recordset.Addnew and returning a sequence value
Posted on 2004-10-06
I have an application which is running fine with MS SqlServer, but it should
be working with Oracle as well.
At a lot of places we rely upon the ADO Recordset to return incremented
Oralce however returns null or zero, but I've seen via isqlplus that the sequence and trigger has done it's job. When I do a Requery at that dataset, the correct values are returned. But I cannot do a Requery because I want to knwo the unique value immediately.
SqlServer, Sybase, MySql all do this properly. How can this be fixed with Oracle easily?
Dim mConn As New ADODB.Connection
Dim rs As New ADODB.Recordset
mConn.ConnectionString = "Provider=OraOLEDB.Oracle;User
rs.Open "select * from testidentity where id < -1", mConn,
rs.AddNew "name", "peter"