processing from .Exe to .Exe

[charlesdenver]

.exe to .exe
ran into an intersting proablem-
when using one compiled.exe to process information then call another .exe for other processing, dbase 5.5 trys to call the second .exe BEFORE completing the first one. since i'm useing the SAME .dbf files in both of course the second .exe can't open them. i've devised a workaround (sleep) based on the number of files to process but that's really 'bush'. Anyone know a REAL solutition.
(I have had NOTHING but trouble useing 'Sessions'and don't belive that is the solution!)
charlesdenver@msn.com

 

[tviman]

Have you tried calling the second exe from a UDF function that returns a value to the first? This would have the same effect as SLEEP but with a little more elegance. Some psuedo code:

function callExe()

define calling parameters
close any data files & indexes (if needed)
call second exe with args
(waiting for second exe to finish... maybe some code to test if operation was successful?)
reopen any tables & indexes
return control to first exe



There's always a better way. The fun is trying to find it!