Need Help With SQL*Forms & Looping Within A Block

I need to know if it is possible and of course how it is possible, to loop through the records in a block and perform some operation on each, but leave you in the same block and record that you started in. For example, you make some
query and retrieve some number of records for the block. Then, maybe a key-trigger or something that will loop through each record and copy a few fields to another table in the database or something. But it would leave the status of the FORM in the same status as when you started the trigger. I would assume that you could do a loop with go_records until some sort of error condition (notfound or something) and accomplish it, but do you know of any "for each record do" construct? Any help would be appreciated.

Thanks,
Dave Barstis
E-mail: david.r.barstis_at_med.umich.edu

"I'm so broke I can't even pay attention!" Received on Thu Jul 08 1993 - 15:04:13 CEST