Hi All.
I'm using the Shell function to run to batch programs. The first batch file starts a database manager and the second batch file creates tables in the database. These two commands are part of one "Create Database" on_click event. Both these commands work perfectly on their own.
My problem is that the firt command MUST complete before the second command is executed. The shell command runs asynchronously, which means that sometimes the second program starts running before the first has completed - causing all kinds of havoc!!
Does anybody know of a way to check if the first program is still running, and only start the second program once the first has completed?
Maybe some kind of Do-While loop?
I'm using the Shell function to run to batch programs. The first batch file starts a database manager and the second batch file creates tables in the database. These two commands are part of one "Create Database" on_click event. Both these commands work perfectly on their own.
My problem is that the firt command MUST complete before the second command is executed. The shell command runs asynchronously, which means that sometimes the second program starts running before the first has completed - causing all kinds of havoc!!
Does anybody know of a way to check if the first program is still running, and only start the second program once the first has completed?
Maybe some kind of Do-While loop?