Create text file 1

[Jerryyang]

how to create a text file from VFP?

I want to create a text file with filename: mybackup.txt
with the content:

mysqldump -%1 -%2 %3 > %4

Thanks for the help.

 

[bborissov]

STRTOFILE("mysqldump -%1 -%2 %3 > %4","mybackup.txt")

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[Olaf Doschke]

STRTOFILE() stores a string (as is) into a file. TEXT...ENDTEXT is another possibility.

* StrToFile is simple in this one line case:
StrToFile('mysqldump -%1 -%2 %3 > %4','C:\somefolder\mybackup.cmd')

* With multiple lines you're better off with TEXT ENDTEXT:
_Text = Fcreate('C:\somefolder\mybackup2.cmd')
Text NoShow
mysqldump -u%1 -p%2 %3 > %4
mysqldump -u%1 -p%2 %5 > %6
mysqldump -u%1 -p%2 %7 > %8
EndText
Fclose(_Text)

Bye, Olaf.

 

[JRB-Bldr]

As you can see by the two differing approaches above, there are a number of ways that VFP can create a Text file.

Additionally:
1. Use COPY TO with an appropriate option
COPY TO NewTxtFile.TXT DELIMITED
COPY TO NewTxtFile.TXT SDF

2. Use low level functions to Write a Text File
FOPEN()
FPUTS()
FCLOSE()
etc.

Good Luck,
JRB-Bldr

 

[DSummZZZ]

Another way is:

MODIFY FILE mybackup.txt

Type in the following line:
mysqldump -%1 -%2 %3 > %4

Then save the file.

My point is, do you now see how vague your request is?


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm