Re: Looping thru all records in base block
From: Anatoly V. Lisovoy <anatoly_at_ftc.ru>
Date: Thu, 30 Apr 1998 10:44:27 +0600
Message-ID: <6i8sbp$dk7$1_at_david.ftc.ru>
Date: Thu, 30 Apr 1998 10:44:27 +0600
Message-ID: <6i8sbp$dk7$1_at_david.ftc.ru>
>Roger wrote:
>
>> I want to loop through all records in a base block of form
>> and do some calculations. Like I would loop thrugh with a
>> cursor stmt in PL/SQL. How do I do it? TIA
goto_block('some_block');
first_record;
--loop through all records in a some_block
loop
<Do some you need>
exit when :system.last_record = 'TRUE';
next_record;
end loop;
Anatoly/ Received on Thu Apr 30 1998 - 06:44:27 CEST