How to assign initial value in ENTER_QUERY mode, URGENT!!!! [message #77532] |
Sun, 30 September 2001 22:57 |
Umesh Sharma
Messages: 14 Registered: February 2000
|
Junior Member |
|
|
Dear Oracle Friends
I am having 2 global variables with some value. I have one form which is set to ENTER_QUERY mode thru the trigger 'WHEN-NEW-FORM-INSTANCE'. My problem is I want to assign the values from the global var. to the fields after setting the form in ENTER_QUERY mode. I tried to assign it in the trigger itself but not succeeded. Can anybody help me.......
Waiting for quick response
Thanks
UMESH
----------------------------------------------------------------------
|
|
|
Re: How to assign initial value in ENTER_QUERY mode, URGENT!!!! [message #77534 is a reply to message #77532] |
Mon, 01 October 2001 03:11 |
Enno Oost
Messages: 12 Registered: October 2001
|
Junior Member |
|
|
Hi Umesh
If i'm getting it right, you want to perform an automatic search at the start of your form using the two global variables in the query.
You can do this insinde the PRE-QUERY-Trigger by simply assigning the values like
:block_name.item_name := :global.var_name;
Attention : the two global variables will be used as search-condition in every query, then.
Ciao ... Enno
----------------------------------------------------------------------
|
|
|