Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: MS Access/ Oracle sequence number problem

Re: MS Access/ Oracle sequence number problem

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/12/17
Message-ID: <678eeh$tph$1@news00.btx.dtag.de>#1/1

Societe Generale Australia Ltd. 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

Hi Ordeon,

try 'SELECT quote_sq.nextval as newnumber from DUAL' as a SQL_PASSTHROUGH-query this will return you the desired value in the field 'newnumber' of the dynaset.

-- 
Regards

Matthias Gresz    :-)
Received on Wed Dec 17 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US