Re: Looping thru all records in base block

If you cannot use Navigation (First_Record, Next_Record etc.), because these are restricted built-ins, you can use the Post command. Post saves the data on the form into the database, then you can use a cursor. If you want to reverse the updates to the database, use rollback.

Hope this helps

Savithri

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
Received on Wed Apr 29 1998 - 16:16:45 CEST