autonumber with oracle

[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

 

[Anne Nolan]

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