Re: Loops in SQL*Forms

In article <01bd6e08$e6e5b750$a46b1389_at_cuppm>, Michael Cupp, Jr. <Mike.Cupp_at_alliedsignal.com> wrote:
>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?

The Loop structure is a pl/sql command, so you need a pl/sql reference manual to see how to use it.

Here are some examples -- (off the top of my head, so it may not be exactly right)

For I in 1..10 Loop
  do_something;
End loop;

Declare cursor c is select col1 from Tab1; Begin
  Go_block(BLK);
  Open c;
  Loop
    Fetch c into :blk.itm1;
    Exit when c%notfound;
    next_record;
  End loop;
  close c;
End; Received on Sun Apr 26 1998 - 03:18:47 CEST