| execute_query [message #80196] |
Thu, 22 August 2002 01:37  |
Margje
Messages: 1
Registered: August 2002
|
Junior Member |
|
|
We want to use execute_query function everytime the form opens.
How can we do this?
We tried to do it this way:
execute_query ('wedstrijdindeling.fmx');
It doesn't work, no data is loaded when the form opens.
So everytime we (and the user off course) wants to see data, F8 must be pushed.
How can we do this automatically, so F8 is no more necessary?
|
|
|
|
|
|
| Re: execute_query [message #80210 is a reply to message #80196] |
Fri, 23 August 2002 22:17  |
Victoria
Messages: 152
Registered: July 2002
|
Senior Member |
|
|
Hi ,
Open the .fmb form file.In side WHEN-NEW-FORM-INSTANCE Trigger you can give:
go_block('your_block_name');
execute_query;
So whichever form you want to be loaded with data,give the above lines in those forms.
Even you can specify where condition of your query at runtime using set_block_property('your_block_name',default_where,'place your where condition here');
The above should be included before execute_query....
I hope it helps you...
Thanks and Regards
Victoria
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
