Help with running multiple RunApp sequentially

[scooper]

Hi

I'm trying to piece together a macro which will invoke an external command but wait for it finish before invoking several queries. My current macro has a RunApp statement that invokes a command to create a data file. It also has several queries that then import that data. My problem is that as soon as the external command is invoked, the macro continues running through the queries. The queries finish before the data file exists

Is there a way I can ask the macro to pause until the external command finishes

Any help is greatly appreciated


Cheers
Shannon

 

[Steve Schapel]

Shannon,

I am afraid the answer is No. As far as I know, the best you can do
here is this...
- split your macro into two macros, being the actions before the "pause"
and those after.
- as the last action in the first macro, use a SetValue action to set
the TimerInterval property of a form which is open at the time, to an
amount which will be sufficient to allow the data import to complete
- Assign the second macro on the On Timer event of the form.

 

[scooper]

Steve

Excellent! That should do the trick - I need only a few seconds to fully import the data. Thanks for your help


Cheers
Shanno

----- Steve Schapel wrote: ----

Shannon

I am afraid the answer is No. As far as I know, the best you can do
here is this..
- split your macro into two macros, being the actions before the "pause"
and those after
- as the last action in the first macro, use a SetValue action to set
the TimerInterval property of a form which is open at the time, to an
amount which will be sufficient to allow the data import to complet
- Assign the second macro on the On Timer event of the form