"copy to" or "export to" a text file... 1

[torturedmind]

another question: how to include the field names when issuing a "copy to" or "export to" a text file? or do i have to do it manually?

kilroy

 

[baltman]

COPY TO has a default scope of ALL. If you want just some fields, you would have to list them.

Brian

 

[torturedmind]

am sorry but i guess i wasn't clear with my question. what i want is to include the NAMES OF THE FIELDS to the target text file (and not just the records only). uhmmm i really apoligize if i couldn't make mayself more clear

kilroy

 

[DSummZZZ]

Just use LIST OFF TO MyFile.txt instead of COPY TO MyFile.txt. (OFF means don't list the record numbers).


-Dave S.-

Even more Fox stuff at:

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

 

[ramani]

HI

COPY TO myNewFileName FIELDS myFieldList TYPE SDF
COPY TO myNewFileName FIELDS LIKE Skeleton TYPE SDF



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[hgirish]

Copy To filename Type csv

Creates a comma separated value file. A CSV file has the field names as the first line in the file, and the field values in the remainder of the file are separated with commas.

 

[torturedmind]

hey thanks to all the replies, especially to hgirish cuz that's the command phrase that i need. maybe i was just really dazed when i look up the "COPY TO" command in the help index that i overlooked at the "TYPE CSV" phrase. and for that, hgirish, i give you a star.

kilroy