Re: MS Access/ Oracle sequence number problem

From: Kaboel Karso <kaboel_at_wau.mis.ah.nl>
Date: 1997/12/17
Message-ID: <349eeeee.24828171@waubel.wau.mis.ah.nl>#1/1

With a SQL passthrough query, you can use Oracle specific syntax.

On Wed, 17 Dec 1997 14:20:31 -0800, "Societe Generale Australia Ltd." <sgal_at_zip.com.au> wrote:

>I seem to have a problem using an Access front end to Oracle7 backend.
>
>I am trying to retreive a sequence number from Oracle, store it as a
>variable and update a record back to the database incorporating this
>sequence number into the 'Quote_number' as my key in my Oracle table.
>
>The SQL statement in Oracle looks like:
>
>SELECT quote_sq.nextval from DUAL
>
>Apparently, DUAL is a virtual table created by ORACLE to hold information
>like the sequence number I need
>
>I have to use the Oracle sequence number and not the MS Access counter
>
>If you have any ideas, please mail me
>
>sgal_at_zip.com.au
>
>Thanking you all very much in advance
>
>Gordon Elliott
>Societe Generale Australia LTD

Kaboel Karso Received on Wed Dec 17 1997 - 00:00:00 CST