Re: Referencing Oracle "Sequences" via Access front end
From: David Gallucci <davegall_at_snet.net>
Date: 1997/01/30
Message-ID: <01bc0e41$714631a0$5f0e3ccc_at_grace>#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 Thu Jan 30 1997 - 00:00:00 CET
Date: 1997/01/30
Message-ID: <01bc0e41$714631a0$5f0e3ccc_at_grace>#1/1
Write the SQL statement as you would if you were using SQLPlus, but - specify it as a Pass Through query in Access. That will shut off the syntax check to the Oracle server.
-DG
"Reality is for people who can't face code."
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 Thu Jan 30 1997 - 00:00:00 CET