Re: FORMS: Set Default Where

Hello,
you can do the next;

when-new-form-instance

set_block_property(block, default_where, the_default_where); execute_query;
set_block_property(block, default_where, '');

You put two ' in the default_where

Bye

BAMAN MOTIVALA escribió en mensaje ...
>Hello,
>
>I want to have FORM_A open FORM_B, pass it a parameter and then have FORM_B
>issue query based on that parameter. I am using SET_BLOCK_PROPERTY('block',
>DEFAULT_WHERE, parameter) in FORM_B's WHEN-NEW-FORM-INSTANCE trigger. This
>is being used to set the master block of a master-detail.
>
>It works but since it sets the WHERE for the rest of the session I cannot
>query any other records.
>
>My Questions:
>1) Should I reset the DEFAULT_WHERE? If so, how can I set it to NULL or
>UNSPECIFIED?
>2) If I do reset the DEFAULT_WHERE, where should I do it? POST-QUERY?
>
>3) Instead of setting the DEFAULT_WHERE in the first place is there another
>way to get the initial result set I want when FORM_B opens?
>
>Thank you,
>
>Baman
>
>
Received on Thu Jul 22 1999 - 15:02:58 CEST