Re: Referencing Oracle "Sequences" via Access front end
From: Authorized User <mmelanco_at_sfi-software.com>
Date: 1997/01/29
Message-ID: <01bc0e21$19cb6140$181bf8ce_at_win95-25>#1/1
> We have an Access 2.0 front end and we have Oracle 7.3 tables attached
> to it.
>
> We have created "sequences" that increment by 1 on the Oracle side, but
> we are having trouble referencing them from the Access SQL (i.e. using a
> statement like INSERT INTO Division (Division_ID) VALUES
> (Division_Seq.NEXTVAL). Access doesn't recognize the
> Division_Seq.NEXTVAL statement.
>
> Any ideas on how to get this to work ?
>
Received on Wed Jan 29 1997 - 00:00:00 CET
Date: 1997/01/29
Message-ID: <01bc0e21$19cb6140$181bf8ce_at_win95-25>#1/1
Create a function that read from the sequence and use the function in the insert statement
Rick Markham <lnusebs.DZM3X2_at_eds.com> wrote in article <32EE64A3.3E12_at_eds.com>...
> We have an Access 2.0 front end and we have Oracle 7.3 tables attached
> to it.
>
> We have created "sequences" that increment by 1 on the Oracle side, but
> we are having trouble referencing them from the Access SQL (i.e. using a
> statement like INSERT INTO Division (Division_ID) VALUES
> (Division_Seq.NEXTVAL). Access doesn't recognize the
> Division_Seq.NEXTVAL statement.
>
> Any ideas on how to get this to work ?
>
Received on Wed Jan 29 1997 - 00:00:00 CET