Re: sequences

In article <1995Jul28.112337.22967_at_ucl.ac.uk>, Mr Angus Beare says...
>
>I need to be able to generate Oracle sequences from an
>application using Oracle Objects for OLE. I can add a new
>record with:_
>
>oradata1.recordset.dbaddnew
>
>however I need the best way of getting the .NEXTVAL for the
>ID of the new record. The data control has no way of linking it to
>a sequence.
>
>I can send a request to the database like 'select SEQ.nextval from samples'
>but this returns a number for every row in the table.

Not knowing anything about the problem:
If select SEQ.nextval from samples works, then

   select SEQ.nextval from sys.dual
should also work, and return exactly one row.

There may be a better solution, but, like I said, I know nothing.

-- 
 _________________________   __________________________________________
/  Tommy Wareing          \ /  I've been looking for an original sin,  \
|  p0070621_at_brookes.ac.uk  X   One with a twist and a bit of a spin    |
\  0865-483389            / \     -- Pandora's Box, Jim Steinman       /
 ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~