Page 1 of 1
Run VFP prg when SQL report is done
Posted: Thu May 10, 2007 2:13 pm
by Conrad_S
I am using RR Infinity SQL to create a VFP dbf. When it is done, I want to call/execute/run a VFP program. Any ideas?
=> Run VFP prg when SQL report is done
Posted: Mon May 14, 2007 9:09 am
by kfleming
You could lauch rswrun.exe from the VFP program and create the DBF before running the code that will use that DBF.____Kathleen__R&R Support
==> RE: Run VFP prg when SQL rep^s done
Posted: Tue May 22, 2007 7:49 am
by Conrad_S
I^m not familiar. If I run rswrun.exe from VFP, how will I know within the VFP program when the table is created so that I can start working on it?
===> RE: Run VFP prg when SQL rep^s done
Posted: Thu May 24, 2007 2:32 am
by SolarisW_(Guest)
The Foxpro program should be able to Poll for the creation of the DBF.____do while !file("drive:/path/myfile.dbf" )__* warning this is an infinite loop if the file is never created__enddo______The prudent step at the start of the program would be to include the deletion of any prior created tables.____if file("drive:/path/myfile.dbf" )__dele file "drive:/path/myfile.dbf"__endif____After multi application of the program and the code might find an older version of the DBF and not pause.
====> RE: Run VFP prg when SQL rep^s done
Posted: Fri May 25, 2007 2:19 pm
by Conrad_S
Thanks for the VFP pointers.