Re: Getting NEXTVAL just prior to a COMMIT

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 Sat Sep 09 1995 - 00:00:00 CEST