Executing query? [message #85025] |
Mon, 24 May 2004 02:53 |
Tomasz
Messages: 13 Registered: May 2004
|
Junior Member |
|
|
Hi
I designed 2 forms(typical search form and insert form) , I want to pass value from first(search) to second(insert form) thought :GLOBAL parameter and executing query with this value on secont form (it will fill form fields).
How to do this?
Is there a simple way to solve this?
|
|
|
Re: Executing query? [message #85039 is a reply to message #85025] |
Tue, 25 May 2004 00:09 |
Anupam
Messages: 62 Registered: July 2001
|
Member |
|
|
before calling a insert_form create a global var
and assign the value;
and on insert form
assign that global_var to any text field in PRE_FORM trigger of insert_form
and when-new-form-instace trigger execute_query
it will take the assign value as search criteria and it ll query;
|
|
|
Re: Executing query? [message #85056 is a reply to message #85039] |
Tue, 25 May 2004 04:36 |
Tomasz
Messages: 13 Registered: May 2004
|
Junior Member |
|
|
Ok:
I do this, but I have to put in:
when-new-form-instance line
go_block('main').
Now it looks like:
if( :GLOBAL.var <> 0) then
go_block('main');
execute_query();
But it ask me: Save changes? and fires full scan query?
|
|
|