Re: How To Generate Sequence Nbr in Forms 3.0

In article <768154723snz_at_wplace.demon.co.uk>, Glenn Nicholas <Glenn_at_wplace.demon.co.uk> wrote:
>In article <2q9dj8$fip_at_news.delphi.com>
> dagmara_at_news.delphi.com "DAGMARA_at_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

   One of the things I noticed when I first did this was that the sequence    numbers were incremented each time by a factor of the number of blocks on    the form. If you are not worried about holes in the sequence number, this a    way to go, but if you are, the then pre-insert method may be better. I assume     that you are working with SQL*Forms 3.0.

Just some thoughts...

-Paul

-- 
===============================================================================
Paul Mickel                               Internet: mickel_at_oes.orst.edu
Database Applications Programmer          UUCP: ..!hplabs!hp-pcd!orstext!mickel
Teledyne Wah Chang - Albany               Albany, OR  97321   USA