Hi All,
We have a program which main task is to append data every month from three sdf files to three dbf datatables in a database and putting some cdx indexes on it. The program takes an hour, and the program runs manually after the raw data is available in the morning.
We have plans to write three exes that run immediately after each sdf job has finished in the night. So there are three batch jobs(Wiskunde,Basisvrz,Contract) which extract data from an adabas database to an sdf file and after finishing it has to run the belonging foxpro exes. It could be possible that 2 exes have simultaneously access to the database (one exe writes data to wiskunde.dbf and other to basisvrz.dbf for example). For now this gives an access error, which I thought I couldn't solve. Is it possible to solve this?
An other solution I thought about is to decouple the dbf files from the database. So each exe returns a free dbf file and a cdx belonging to this file. And in the morning I just could copy these files and overwrite the dbf files in the directory with the database. Could this work? Or are there some pitfalls?
Thanks beforehand.