I have an old dbase 5 program that needs to send data using FTP. The problem I am having is that the new file needs to be mixed case, i.g., ddExport.txt where the E is upper case. When I create the file using
COPY TO ddExport.txt delimited it creates DDEXPORT.TXT I am sure that I had it working right during the testing phase, but when I went to run the program for real it creates upper case file names only. What am I doing wrong?
Thanks for your assistance
Apparently dbase only creates uppercase file names. The work-around I had to use was to rename the file on the host computer via FTP once it was sent. I tested this method and it works. Sad you can't create lower case file names, it would have been so much simpler.
On the work around side, you could also have a batch file, rename or copy to another file name, your output file. Run the process thru a batch file to execute the actual program and rename the file for you on the way out.