Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with file copy
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01613217
Message ID:
01613223
Views:
45
>>hh="d:\outmail\out"+TTOC(DATETIME())+".dbf"
>>hh=STRTRAN(hh," "+"")
>>hh=STRTRAN(hh,":"+"")
>>hh=STRTRAN(hh,"/"+"")
>>
>>
>>the value of hh is d:\outmail\out07012015084913.dbf
>>
>>SELECT outmail
>>
>>COPY TO &hh
>>
>>I get invalid path or filename - what am I doing wrong?
>>
>>d:\outmail dirctory exists exists as does the file outmail
>
>Do not use macro, use Name expression instead.
>Also make sure that "d:\outmail\ folder exists
>
>hh="d:\outmail\out"+TTOC(DATETIME())+".dbf"
>
>hh=CHRTRAN(hh," :/", "")
>
>SELECT outmail
>TRY
>   md ("d:\outmail\") && It is closed in quotes and brackets just in case there are spaces in the folder name
>CATCH
>ENDTRY
>
>COPY TO (hh) && Here
>
I still get the error - d:\outmail exists
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform