>>>SCAN
>>>cTableName = SUBSTR(TEMPDBFFIX.TABLE, AT('\', TEMPDBFFIX.TABLE,1)+1)
>>>cFileName = lcTemplatePath + 'TEMPLATE\DATA\' + TRIM(cTableName) + '.*'
>>>*-- Delete all tables in Template Data directory
>>>DELETE FILE cFileName
>>>*-- Copy files from production fileshare to backup template on server
>>>cTableName = OAPP.CDEFAULT + TRIM(TEMPDBFFIX.TABLE) + '.*'
>>>COPY FILE cTableName TO cFileName
>>>ENDSCAN
>>
>>What you are doing *should* work. Your problems may lie in the latency of your network or OS. If you are running a virus software, your program may be doing this too quickly.
>>
>>I am taking a WAG as to what exactly is wrong... if you have a specific problem or error you might want to post it.
>
>
>I am not getting an error message, when the commands run it just continues like nothing was wrong but doesn't actually do anything. If I run DELETE FILE 'c:\template\data\file.dbf' in the command window it deletes it just fine, but it won't do it with the variable.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown