autonumber with oracle

  • Thread starter Thread starter reynard
  • Start date Start date
R

reynard

I've an MS Access database that I use as GUI and an Oracle database for the
data.
In Oracle I've tables with autonumber (created with a sequence and a
trigger)
How can I get back the autonumber when I do an insert with a ADODB
recordset?

I tought quering the sequence but since it's not a linked table, I've no
access to it....

Michel
 
One way is to run a Pass-Through query to retrieve the current value of your
sequence (assuming nobody else has used the sequence in the meantime):

SELECT MY_SEQUENCE.CurrVal from DUAL;

Hope this helps,

Anne Nolan
 
Back
Top