Re: 96781 Looping through multirecord block

Try

While :system.last_record = 'FALSE loop

     NEXT_RECORD;
     item_to_change := new_value;

HTH Mark

kevinr75_at_my-dejanews.com wrote in message <7dt8ib$olr$1_at_nnrp1.dejanews.com>...
>This is probably a pretty simple one.
>
>I have a multirecord block diplayed as a table.
>I want to loop through the thing a change a single field in each record.
>
>I figure it will probably work something like this
>
>LOOP
> IF LAST RECORD THEN EXIT END IF; ***
> NEXT_RECORD;
> item_to_change := new_value;
>END LOOP;
>
>My problem is that I dont know how to exit the loop - how do I tell when I
am
>at the last record in a block.
>
>Thanks.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Mar 31 1999 - 16:57:22 CEST