Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I import a word doc into memo field
Message
From
20/04/2015 08:42:54
 
 
To
20/04/2015 08:32:03
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:
01618713
Message ID:
01618762
Views:
29
>>>>>>>
REPLACE mMemo WITH FILETOSTR(cDocFile)
>>>>>>
>>
>>my code
>>
>>REPLACE wordin WITH FILETOSTR("c:\my documents\colinnewnotes.doc")
>>
>>Wordin is a memo field
>>
>>What I get is a lot of rubbish in wordin
>>
>>What am I doing wrong?
>
>Storing Word docs in memo fields is a very bad idea, but if you want to anyway, there are some ways:
>
>1) You can create a General field and use APPEND GENERAL (see help file)
>
>2) You can create a binary memo (with NOCPTRAN) and use the same replace you intended to use
>
>3) Save in a normal memo field but converting to base64 with STRCONV()
>
>Regards.-

Rule #1: Avoid general fields, at all cost
Rule #2: If you absolutely must use a general field, see rule #1.
Previous
Reply
Map
View

Click here to load this message in the networking platform