I'm using a global variable to set the connection string for an oracle application login. The Idea is to use one place to change the value instead of trying to change the value in multiple places. I thought that I could use the File Replace command to replace the values in the connection string. Below is the code that I am using

DIM FOUND number

FileReplaceEx("D:\My Documents\Tech Appraisal Extracts\","Inventory Extracta.bat","X1X2/X3",global.newconnection,false, found)

When the job runs, I get an error message but no details and when I look at the file the file has not been changed. I noticed that when I run the job in debug mode it seems to work..

Any suggestions?

FileReplaceEx("D:\\My Documents\\Tech Appraisal Extracts","Inventory
Extracta.bat","X1X2/X3",global.newconnection,false, found)

: I'm using a global variable to set the connection string for an oracle
: application login. The Idea is to use one place to change the value
: instead of trying to change the value in multiple places. I thought that I
: could use the File Replace command to replace the values in the connection
: string. Below is the code that I am using

: DIM FOUND number

: FileReplaceEx("D:\My Documents\Tech Appraisal
: Extracts\","Inventory
: Extracta.bat","X1X2/X3",global.newconnection,false, found)

: When the job runs, I get an error message but no details and when I look at
: the file the file has not been changed. I noticed that when I run the job
: in debug mode it seems to work..

: Any suggestions?

: FileReplaceEx("D:\\My Documents\\Tech Appraisal
: Extracts","Inventory
: Extracta.bat","X1X2/X3",global.newconnection,false, found)

Still have the same issue. Doesn't work when clicking on Run now,but will work when debugging the script.

Make sure you don't run this job detached, becasue in the current version detached jobs have no access to the global variables memory.

: Still have the same issue. Doesn't work when clicking on Run now,but will
: work when debugging the script.

: Make sure you don't run this job detached, becasue in the current version
: detached jobs have no access to the global variables memory.
Still having the same problems. I have taken off the check mark for detached job.

Add a message box for the global variable to see the value when the script runs.
I still think the problem is in the file name or path. Please make sre it is correct and the D: drive is accessible to the account running the scheduler. Also try specifying "*.bat" for the file name. Also note that the search is case-sensitive.

: Still having the same problems. I have taken off the check mark for detached
: job.