Re: Looping through Selected records -- Simple

Hi Amardeep,

The easiest way is to do a First_Record and then loop through all records with Next_Record.

Here's an example, which also returns to the current record afterwards:

save_record := :System.Cursor_Record;

First_Record;

keep_looping := TRUE;

WHILE keep_looping
LOOP
  your-program-logic
 IF :System.Last_Record = 'TRUE'
 THEN
   keep_looping := FALSE;
 ELSE
   Next_Record;
 END IF;
END LOOP; Go_Record(save_record);

Amardeep Johar <amardeep.johar_at_shell.ca> wrote in article <34F9FFAD.4649_at_shell.ca>...
> Hello Oracle gurus!,
>
> I just had a simple question about Forms 4.5. Since I am new to it, I am
> having a little trouble with it.
>
> I need to know how I could loop through all the records in a block? I
> want to be able to loop through and pick up all those records whose
> corresponding checked value (I have check boxes) is checked (or
> unchecked WLOG).
>
> There probably is a very simple solution to this and I would appreciate
> a reply either posted to the newsgroup or via email to me at
>
> amardeep.johar_at_shell.ca
>
> Thank you for your time and help.
>
> Regards,
>
> Amardeep
>
Received on Mon Mar 02 1998 - 00:00:00 CET