Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to quickly look at Memo files, converting table to a
Message
From
16/01/2013 19:25:51
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01563035
Message ID:
01563064
Views:
42
Try using SCATTER MEMO TO laArray in a SCAN-ENDSCAN loop. This gives each of the fields into an array which then can be directed to a file:
lcOutput = ""
SCAN FOR !DELETED()
   SCATTER MEMO TO laArray
   FOR lnNdx=1 TO ALEN(laArray,1)
      lcOutput = lcOutput + laArray[lnNdx] + CHR(9)
   ENDFOR
   lcOutput = lcOutput +CHR(10) + CHR(13)
ENDSCAN
FILETOSTR(lcOutput, "MyFile.txt")
Previous
Reply
Map
View

Click here to load this message in the networking platform