Re: Oracle Sequence for generating IDs

From: Matthias Gresz <GreMa_at_t-online.de>
Date: Fri, 15 Jan 1999 12:16:46 +0100
Message-ID: <369F239E.F5A34DE2@Privat.Post.DE>

Paul schrieb:
>
> I am using sequences to generate primary keys for tables. If I use
> triggers to generate the next ID in the sequence automatically what is
> the best way to find out what ID was generated in Visual Basic. Any
> help is appreciated.
>
> Paul

You need the ID 'cause you want to add parent and child record in the same transaction?

one way to get this is to not use triggers, but to preselect the ID store it in a VB-variable and use it creating the parent as well as the child.
other way may be using SP's and returning the ID as parameter

HTH
Matthias
--
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Fri Jan 15 1999 - 05:16:46 CST