96781 Looping through multirecord block

From: <kevinr75_at_my-dejanews.com>
Date: Wed, 31 Mar 1999 13:39:24 GMT
Message-ID: <7dt8ib$olr$1_at_nnrp1.dejanews.com>

[Quoted] 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 [Quoted] 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 - 15:39:24 CEST