I want to use a script to set directory\sub-directories for the path of a copy operation. The path changes each time I perform a copy and it would be nice to do it this way versus going in and changing each time I change data that is copied.
The example- I have the following never changing and main directory
c:\districts
In this never changing directory there are sub-directories for different sales divisions. For this purpose we will call one division
test
In each division there are unique districts identified by unique and different numbers. In this case we will use the number (character) 10.
I want to execute a copy of specific data for a specific district (based on a filter in the copy operation) from a main database that contains all the districts data to a smaller database designed for a single district.
So, the directory would look like this
c:\districts\test\10
I would copy a file to this directory called
tempdisthh
Hence I ultimately want this to happen
copy_db_name = filename_decode c:\districts\test\10\tempdisthh.dbf
I have two global variables obtained from a Dialog Box
copydivision
copydistrict
The copydistrict variable plugs into the filter portion of the copy operation as well as in setting the directory.
Where my struggle comes in is
copy_db_name = filename_decode ("c:\district\"+Var-"copydivision+"\"+Var-"copydistrict+"\"+"tempdisthh.dbf") does not seem to work.
The script runs without error messages but no copy operation occurs. The actual script is posted in next message.
Suggestions?
The example- I have the following never changing and main directory
c:\districts
In this never changing directory there are sub-directories for different sales divisions. For this purpose we will call one division
test
In each division there are unique districts identified by unique and different numbers. In this case we will use the number (character) 10.
I want to execute a copy of specific data for a specific district (based on a filter in the copy operation) from a main database that contains all the districts data to a smaller database designed for a single district.
So, the directory would look like this
c:\districts\test\10
I would copy a file to this directory called
tempdisthh
Hence I ultimately want this to happen
copy_db_name = filename_decode c:\districts\test\10\tempdisthh.dbf
I have two global variables obtained from a Dialog Box
copydivision
copydistrict
The copydistrict variable plugs into the filter portion of the copy operation as well as in setting the directory.
Where my struggle comes in is
copy_db_name = filename_decode ("c:\district\"+Var-"copydivision+"\"+Var-"copydistrict+"\"+"tempdisthh.dbf") does not seem to work.
The script runs without error messages but no copy operation occurs. The actual script is posted in next message.
Suggestions?
Comment