Grabbing an external parameter

[pablo_tx]

I have a number of files that I will be importing via ODBC. With each file I need to execute a script to do two thing in another table; create records for new data and update a modified date on existing records. On top of all this a .Net application will be controlling the ODBC import operations. My thinking is that after each import I would have the .Net application create a file with some value that represents the specific import. The .Net application would also call a FMP driver database that upon opening would execute a script that would get the value from the file and run the appropriate import validation script.

Is this possible and if so what is the best way to set it up?

Edited August 2, 2008 by Guest