getting ident_current into a vb variable
Posted on 2004-11-08
I have an insert statement that I have run through adodb.recordset.
now I am trying to get the primary key out of the database using Scope_identity() function .
I do not know how to call the value of it to vb.
I thought I could do selct statement
intOrderID = rs.Fields("IDENT_CURRENT").Value
but does not seem to work? any ideas?