Hi,
I wish to create a unique output file for each user hitting my web based application (DLL). The SYS(2015) call does this nicely, but I can't figure out the code to use with the COPY TO in order to refer to this file. I am sure that I am missing something fundamental here!

After validating my user name and password I assign a unique file name.

THIS.cUserXLSFile = "DIR" + SYS(2015) + ".XLS"

I would like my query builder to to use the newly created file, for this user, overwriting any previous file with the same name. This function is called for all queries.

COPY TO THIS.cUserXLSFile TYPE XL5

If I include the COPY TO "DIR" + SYS(2015) + ".XLS" things work as planned, except that I do not want a unique file every time this part is called in my procedure.

How can I get VFP to use my THIS.cUserXLSFile reference within my query buildr function ?

Any assistance would be greatly appreciated.


Andrew Logie

Institute of Food Research
logiea@bbsrc.ac.uk