HI All,
I am doing a temporary work around for something that is needed NOW and I don't have time to do the rewrite til later... For the short term, I need to create an Export statement that will send a filtered set of records to an Excel file -- Not a problem, except that the modal form to set it up creates the statement has to accept user input to determine what the filter is and the file location/name.
so the statement I need to duplicate is:
COPY TO 'c:mypreferredfoldermyfilename.xls' TYPE XLS for mypreferredfield myoperator myvariable
example: COPY TO 'c:my documents hisfile.xls' TYPE XLS for county = 'Fresno'
the part that isn't working is after the FOR statement, I haven't tried WHILE but suspect I'd get the same result.
When I create it at the command line, and look at the variables, it all looks right, but the COPY TO command doesn't interpret it correctly. Is there an easy solution for this?
Lynette
Lynette
ltillner AT yahoo .DOT com
©2001 Lynette Tillner |
