Re: Returning Sequence Numbers In VB

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 8 Jan 2001 21:12:36 +0100
Message-ID: <93d6s1$9po6u$1@ID-62141.news.dfncis.de>

Wrap the call to the sequence in a stored procedure and call the stored procedure before insert of the record, or better still : leave the sequence generation to an Oracle before insert trigger.

Hth,

Sybrand Bakker, Oracle DBA

"Ben Ralph" <ben_at_ralph.demon.co.uk> wrote in message news:978982105.18343.0.nnrp-10.c2de4ac6_at_news.demon.co.uk...
> When writing a new record to an Oracle table how can I have the sequence
> number returned to my VB app.
>
> --
> Ben Ralph
> MCP
>
>
Received on Mon Jan 08 2001 - 14:12:36 CST