Home » Developer & Programmer » Forms » Forms
Forms [message #79400] Thu, 06 June 2002 13:48 Go to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
In forms - What's the best way to allow querying on a field which is not part of the underlying view/table.

Thanks in advance!!
Ravi
Re: Forms [message #79454 is a reply to message #79400] Tue, 11 June 2002 10:10 Go to previous messageGo to next message
rosey
Messages: 13
Registered: May 2002
Junior Member
Ravi,

Can you give some more details? I'll see if I can help you.
Re: Forms [message #79458 is a reply to message #79454] Tue, 11 June 2002 14:10 Go to previous messageGo to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
I am trying to allow to query on a field in a form which is not part of the base view. Since the field is not part of the base view when the form is put in the enter-query mode it does not allow the user to query on this field.

I guess modifying Pre-query would be an option?
Re: Forms [message #79465 is a reply to message #79454] Wed, 12 June 2002 06:26 Go to previous message
rose
Messages: 7
Registered: October 2001
Junior Member
You may just want to set a where clause in the details block's WNII trigger:

SET_ITEM_PROPERTY('BLOCK_DTL', DEFAULT_WHERE, EMP_NAME = BLOCK_MSTR.EMP_NO);

Let me know if you still need a hand.
Rose
Previous Topic: Getting the position of the prompt in a TextItem
Next Topic: Default where - URGENT
Goto Forum:
  


Current Time: Thu Mar 28 19:46:31 CDT 2024