Home » Developer & Programmer » Forms » execute_query
execute_query [message #80196] Thu, 22 August 2002 01:37 Go to next message
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 #80204 is a reply to message #80196] Thu, 22 August 2002 21:22 Go to previous messageGo to next message
Kamran Laeeq
Messages: 3
Registered: August 2002
Junior Member
Just give statement
execute_query;
on trigger
When_New_Block_Instance
Re: execute_query [message #80210 is a reply to message #80196] Fri, 23 August 2002 22:17 Go to previous message
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
Previous Topic: FRM-40010 error
Next Topic: URGENT urgent
Goto Forum:
  


Current Time: Fri Mar 29 00:06:01 CDT 2024