From: dagmara@news.delphi.com (DAGMARA@DELPHI.COM)
Newsgroups: comp.databases.oracle
Subject: How To Generate Sequence Nbr in Forms 3.0
Date: 5 May 1994 00:11:20 -0000
Organization: Delphi Internet Services Corporation
Lines: 15
Message-ID: <2q9dj8$fip@news.delphi.com>
NNTP-Posting-Host: news.delphi.com


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.

Any help would be greatly appreciated.

Dagmar

dagmara@delphi.com