Newsgroups: comp.databases.oracle
From: Glenn@wplace.demon.co.uk (Glenn Nicholas)
Subject: Re: How To Generate Sequence Nbr in Forms 3.0
References: <2q9dj8$fip@news.delphi.com>
Organization: Concept
Reply-To: Glenn@wplace.demon.co.uk
X-Newsreader: Demon Internet Simple News v1.27
Lines: 22
Date: Thu, 5 May 1994 16:18:43 +0000
Message-ID: <768154723snz@wplace.demon.co.uk>
Sender: usenet@demon.co.uk


In article <2q9dj8$fip@news.delphi.com>
           dagmara@news.delphi.com "DAGMARA@DELPHI.COM" writes:

:
:I admit I am feeling frustrated and foolish right now; but it's been several
:years since I have done forms development.  I am enhancing our CASE tool
:(ORACLE V6) by creating an additional repository and want to create a V3
:form for data entry and querying.  I have a master-detail block, and a
:unique number generated by a sequence as the key.  Here is what I can't
:remember; 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.
:

See section 12-10 of the Forms 3 Manual. Include a default value for
the field in the following format:
  :sequence.order_number.nextval

Otherwise, use the pre-insert method.  

-- 
Glenn Nicholas.