Re: FORMS: Set Default Where

Hi,

In answer to 3) an alternative is to create a Pre-Query trigger which checks whether the passed param is null, and if not then sets the base table item to be queried. Then set the passed param to null so it only occurs the first time.

By the way, you can reset the DEFAULT_WHERE by setting it to a blank string, ' '.

BAMAN MOTIVALA wrote in message ...
>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 Wed Jul 21 1999 - 06:15:31 CEST