General information
Title:
&substitution problem
Just discovered a problem in some 5 year old code. I run a query and store to a cursor. I then launch some code to export the results to either a .dbf or .xls file after choosing the save location, filename, and type. I end up with a variable such as:
loc = "C:\BRUCE COVEY\export.xls" or "C:\BRUCE COVEY\export.dbf"
I then issue:
COPY TO &loc TYPE XL5 or COPY TO &loc depending on selection.
PROBLEM:
Command always fails with nerror 36 if there is a SPACE in any of the folder names. If I change the folder above to "BruceCovey" it works fine.
Does anyone have insight on this?
Would be much appreciated.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only