Re: Getting NEXTVAL just prior to a COMMIT

Better yet, try ON-INSERT trigger. This fires for each row that is inserted in the database. PRE-COMMIT trigger fires only ONCE per commit.

Ashok Kapur
akapur_at_thomtech.com
jhas_at_ix.netcom.com (Swapan Jha ) wrote:
>In <42qn25$fm6_at_its.hooked.net> Craig Harper <caharper_at_hooked.net>
>writes:
>>
>>We are looking for suggestions on how to assign an ID number based on
 the
>>NEXTVAL of a sequence generator, after all the other fields of the
 table
>>have been filled in.
>>
>>The data will be entered through forms 4.5, I know that we can control
 

>>the navigation, thus enabling us to enter the data for the other
 fields
>>befor getting the nextval, but what trigger, or combo of triggers,
 would
>>I use to perform this feat of magic. I can set it up so that I start
 with
>>a when_button_pressed trigger, but then what?
>>
>>If anyone could point us in the right direction, Well thanks in
 advance,
>>and many blessing to you and yours.
>>
>>Craig Harper
>>
>
> Try Assigning the Seq.Nextval in the Pre-commit trigger (Block or
>Form Level)
>
>
> i.e.
>
> :block.item := Seq.NextVal;
>
>
>Hope this helps
>
>Swapan Jha
Received on Fri Sep 15 1995 - 00:00:00 CEST