Re: FORMS: Set Default Where

BAMAN MOTIVALA wrote:
>
> 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
1) use SET_BLOCK_PROPERTY('block', DEFAULT_WHERE, 'field = field') 2) Not post-query as this will fire for every row, do it after the call to execute_query.
3) not really any worth considering

-- 

_/_/__/_/__/_/__/_/__/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
                                                                   
     /\        Russell
Herbert                                                                   
     \ \       Sun Microsystems Ltd.      
    \ \ /      Camberley                             
   / \// /     Surrey                                       
  / /  \//\    GU15 3XD     
  \//\  / /    United Kingdom      
   / //\ /     Tel:      (44) 01276 689341     
    / \ \      Fax:      (44) 01276 677636 
     \ \       Internet: http://www.sun.co.uk 
      \/       E-mail:   russell.herbert_at_uk.sun.com

_/_/_/_/_/_/_/_/_/___/_/__/_/__/_/__/_//_/_/_/_/_/_/_/_/_/_/_/_/_/_/