Re: Loops in SQL*Forms

More info here:

This is a KEY-COMMIT trigger in my forms 4.5 form:

:ONE.MSG := :SYSTEM.MESSAGE_LEVEL;
:SYSTEM.MESSAGE_LEVEL := 5;
:ONE.TEMP := :ONE.ADJ_QTY - :ONE.F_ONHAND;

   Insert into fsp_inv_adj
   values(:ONE.BATCH_NO, :ONE.BATCH_DATE, :ONE.PART_NO, :ONE.CONTRACT, :ONE.LOCATION_NO, :ONE.TEMP, :ONE.REMARKS, :ONE.USER_NAME, SYSDATE);    commit;
Else

   Show_erroralert('No changes to commit.'); End If;
:SYSTEM.MESSAGE_LEVEL := :ONE.MSG; My situation is, my base table is PART_LOC and I want to take the ADJ_QTY value and insert into fsp_inv_adj the record as above. My detail block (Block ONE) has multiple records, and I'm only inserting the record the cursor is on. Please help, this is an urgent matter.

Michael Cupp, Jr. <Mike.Cupp_at_alliedsignal.com> wrote in article <01bd6e08$e6e5b750$a46b1389_at_cuppm>...
> I am attempting to create a loop in SQL*Forms 4.5.
>
> I have never done a loop, and am looking for 'Loop' in all of the
> documentation that I have available, and cannot find any. Can anyone
help
> me with the 'Loop' function?
>
> Thanks already.
> Michael
>
Received on Wed Apr 22 1998 - 18:21:26 CEST