Re: Looping thru all records in base block
From: VIAENEH <VIAENEH_at_nospam.btmaa.bel.alcatel.be>
Date: Mon, 27 Apr 1998 12:57:22 -0700
Message-ID: <3544E322.5546_at_nospam.btmaa.bel.alcatel.be>
Date: Mon, 27 Apr 1998 12:57:22 -0700
Message-ID: <3544E322.5546_at_nospam.btmaa.bel.alcatel.be>
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:
- Create a button on the form, make it run a Program Unit at the OnClick event
- In the program unit, create a cursor, retrieving all fields you need from the base block and storing these in global variables.
- 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")
- 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")