Re: Forms4.5 Query

From: Loyal Barber <lbarber_at_ix.netcom.com>
Date: 1996/10/08
Message-ID: <325A7323.2F55_at_ix.netcom.com>#1/1


Gudla wrote:
>
> I have a multi-record block.
>
> From a trigger i execute a 'SELECT' statement and want to populate
> the multi-record block with all the resultant records from the 'SELECT'.
> How do i do this without using Record-Groups?
>
> Thanks
> Gudla.
1. Declare a cursor for your select statement. 2. Clear the multi-record block. (use a go_block ('name'); then clear_block etc)
3. Use a cursor loop (cursor for loop will do fine) to process inidividual rows.

4. After fetching a row, populate the items in you multi-record block.
5. go to the next record with next_record;
6. after the loop go back to the top of the multi-record block.

Loyal Received on Tue Oct 08 1996 - 00:00:00 CEST

Original text of this message