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:
01613219
Views:
63
>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform