Re: How To Generate Sequence Nbr in Forms 3.0

dagmara_at_news.delphi.com (DAGMARA_at_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_at_notes.tssi.com, dbms_at_genie.geis.com
(posted from nolan_at_helios.unl.edu)