Re: Forms4.5 Query

In article <53braj$88i_at_aeon.ecte.uswc.uswest.com>, Gudla <sgudla_at_ecte.uswc.uswest.com> 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?

First, beware: If you use this method and you want to update the table you are SELECTing from, all your updates will need to be done from additional pl/sql procedures. You have NO automatic processing.

Set up your select in a cursor.
do a go_block to the block (and clear_block if necessary) open the cursor.
in a loop, fetch each row from the cursor into the items in the block. do a next_record.
repeat the loop until the fetch returns %notfound. close the cursor.
do a first_record.

HTH
Steve Cosner Received on Tue Oct 08 1996 - 00:00:00 CEST