Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to copy memo field to text file
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01608919
Message ID:
01608923
Views:
45
>>>>My table has records with only a memo field
>>>>
>>>>How can I copy the data to a text file - when I try I get nothing copied
>>>
>>>One simple possibility would be to scan the table and write the memo field into a file using either low-level file functions or strtofile.
>>
>>Yes I agree - could you give me some code - I have been wrestling with this one for ages
>>
>>Shanah Tovah
>
>
>By the way the length of the memo field is in excess of 300 characters
use myTable in 0 alias workfile shared
scan
   strtofile(myMemoColumn + char(13) + chr(10), 'myFileNameWithFullPath', 1)
endscan
From the top of my head.

Shana Tovah!
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform