Re: Access / ODBC / Sequences

Tony Scott wrote:
>
> I've got Access connected to the Oracle tables I'm interested in via ODBC
> but in order to input new records I need to be able to get the numbers
> generated by an Oracle sequence. Can anyone tell me how I do this?
>
> TIA
>
> Tony Scott

Hi, Tony,

try the following:

SELECT MY_SEQUENCE.CURRVAL FROM DUAL; Don't use MY_SEQUENCE.NEXTVAL, the sequence will increase.

Hope you can use it.

Greetings, Juergen Received on Fri Oct 04 1996 - 00:00:00 CEST