| Variables in enter_query? [message #86848] |
Wed, 10 November 2004 04:02  |
Richard
Messages: 44
Registered: May 2000
|
Member |
|
|
Hi there,
How can i use variables in enter_query mode?
I use Oracle Forms 9i.
I want to realise a automatic search. I get 2 paramters and these parameters (global variables) have to be used as search arguments.
when-new-form-instance:
:global.param1 := 1;
:global.param2 := 2;
enter_query;
pre-query:
:block.item1 := :global.param1;
:block.item2 := :global.param2;
When I run this fmx, then the form is correctly in enter-query-mode, but nothing is shown ... where is my error?
And how can I make an automatic search?
Thanks for your help!
Greets, R.
|
|
|
|
|
|
| Re: Variables in enter_query? [message #86859 is a reply to message #86848] |
Sun, 14 November 2004 20:24  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
The pre-query trigger is executed AFTER you press execute-query!
So, after you press execute-query, the variables are used in the query, overwriting values you manually entered.
I don't doubt whether what you want is possible at all; the stage between enter-query and execute-query is not affected by triggers. It is very hard to get in programmatically.
The only place I can think of are the key-entqry trigger.
hth
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
