Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy to
Message
 
To
09/12/2004 15:18:07
Todd Brown
Teachers Credit Union
Granger, Indiana, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00968105
Message ID:
00968149
Views:
9
>We want to copy a file , delimeted with the header row.

In addition here an example, but it not working well if you have some TABs in fields:
IF SELECT("YourTableAlias") == 0
   USE YourTable ALIAS YourTableAlias IN 0
ENDIF
c_title = ""
FOR asd = 1 TO FCOUNT()
    c_title = IIF(asd==1,"",";")+FIELDS(asd)
NEXT
_VFP.DataToClip("YourTableAlias",,3)
c_title = c_title + +CHR(13)+CHR(10)+STRTRAN(_cliptext,CHR(9),";")
STRTOFILE(c_title,"Text.TXT")
****** Update

There is no need to run the Cikle
IF SELECT("YourTableAlias") == 0
   USE YourTable ALIAS YourTableAlias IN 0
ENDIF
_VFP.DataToClip("YourTableAlias",,3)
c_title = c_title + +CHR(13)+CHR(10)+STRTRAN(_cliptext,CHR(9),";")
STRTOFILE(c_title,"Text.TXT")
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform