Re: a forms question

Hi,

why use cursors ? If you use them, you won't be able to update the data (easily).
why not make the base table of your detail block the requested table and put this code into your when-button-clicked event:

   Set_Block_Property('detail_block', DEFAULT_WHERE, 'Field1=:master_block.search_key1 AND ...');

   Go_Block('detail_block');
   Execute_Query;

Hope this helps !

Regards,
Ramin

srallapally_at_schenkerusa.com wrote in message <6s3tcn$f8r$1_at_nnrp1.dejanews.com>...
>Hi, I am a newbie to forms. please bear me out. I am trying to write a form
>which has a detail block which needs to be populated based on search keys
>entered in any of the text items in a block called search keys. i wanted to
>use a when-button-clicked event to open a cursor and populate the detail
>block. But, i don't know how to handle multiple records returned. any tips?
>tia, sanjay
Received on Fri Aug 28 1998 - 09:22:28 CEST