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>


>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

Original text of this message