From: nolan@helios.unl.edu (Michael Nolan)
Newsgroups: comp.databases.oracle
Subject: Re: How To Generate Sequence Nbr in Forms 3.0
Date: 5 May 1994 03:48:46 GMT
Organization: University of Nebraska--Lincoln	
Lines: 15
Message-ID: <2q9qau$t52@crcnis1.unl.edu>
References: <2q9dj8$fip@news.delphi.com>
Reply-To: nolan@helios.unl.edu
NNTP-Posting-Host: helios.unl.edu


dagmara@news.delphi.com (DAGMARA@DELPHI.COM) writes:

>how the heck do I get the value from the sequence into my key
>field???  In forms 2.3 I would have written a pre-insert trigger, but I
>seem to vaguely recall there is a simplier way of doing this in 3.0.


That's probably the easiest way to do it in Forms 3.0, too.  It also has
the advantage of not assigning the sequence number until commit time,
thus not 'wasting' numbers when the transaction is aborted before it is
committed.
---
Michael Nolan, Sysop for the DBMS RoundTable on GEnie
nolan@notes.tssi.com, dbms@genie.geis.com
(posted from nolan@helios.unl.edu)