FORMS: Set Default Where

[Quoted] [Quoted] 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 Tue Jul 20 1999 - 09:28:31 CEST