Re: Looping thru all records in base block

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

In case you mean the form to loop tru all records without user interaction: I did it like:

1. Create a button on the form, make it run a Program Unit at the OnClick event
2. In the program unit, create a cursor, retrieving all fields you need from the base block and storing these in global variables.
3. In the cursor loop, fetch the cursor and on each fetch execute the appropriate calculations --

   ---

   • A L C A T E L T E L E C O M ****************** Herman Viaene Berkenrodelei 33, B-2660 Hoboken, Belgium Division: Radio Space and Defence Tel: (32/3)8295591 Fax: (32/3)8295502 OIS-mail: viaeneh_at_AM_at_BTMA97 Internet-mail: viaeneh_at_btmaa.bel.alcatel.be X400: Viaene Herman (C=BE,A=RTT,P=ALCANET,OU1=BELA1,O=ALCATEL,S="Viaene",G="Herman")

     ---