I am creating a file name and then trying to create that file with data from a single record in a table a table - what am I doing wrong?
SELECT collections
refa="c:\driver\"+ALLTRIM(str(collections.refno))+ALLTRIM(collections.driver)+".csv"
Copy To refa DELIMITED WITH "" WITH CHARACTER "|";
FIELDS acclient,acad1,acad2,acad3,acad4,accontact,actel,coldate,readyat,closedat,notes,commodity,pieces,weight,globcutoff
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing