I need to have a button on a form initiate an executable using the "shell" command, then "wait" for the executable to complete, and then (and only then) begin some processing.
The executable is an external (non-access) program that updates some SQL tables, and i need to process these tables once the executable has completed the update process.
The SHELL command returns a Windows handler ID for the process that it initiates - can anyone help me with the API call that I would have to execute in a "do...while" loop to wait for the process to terminate?
Thanks!
Vinay
vmehta@vmsc.com
The executable is an external (non-access) program that updates some SQL tables, and i need to process these tables once the executable has completed the update process.
The SHELL command returns a Windows handler ID for the process that it initiates - can anyone help me with the API call that I would have to execute in a "do...while" loop to wait for the process to terminate?
Thanks!
Vinay
vmehta@vmsc.com