| Forms [message #79400] |
Thu, 06 June 2002 13:48  |
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 #79458 is a reply to message #79454] |
Tue, 11 June 2002 14:10  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
