Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with file copy
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01613217
Message ID:
01613219
Vues:
62
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform