Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
General field by the use of the marker
Message
From
11/12/2009 12:14:45
 
 
To
11/12/2009 06:15:03
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01438561
Message ID:
01438632
Views:
57
>When I was checking directions for saving pictures in table fields
>I got many advices about NEVER using "General Fields" for doing anything
>because, as many users said, not only the file data is stored in the field but also
>other informations like default application. One user said it stores even
>"the colors of your grandmother shoes" :)).
>I think your problem is that when you restore the data from the field
>other information is coming in the file making it corrupted for the application
>that uses it.
>If it's a VFP table try to see if Blob is good. According to VFP documentation:
>"To store binary data of any kind, such as ASCII text, an executable (.exe) file,
>or a stream of bytes, and with indeterminate length, use the Blob data type."
>I'm just guessing, but I can make some tests.

I have never used general field.I have to clean up something based on a client's request.

From Sergey's message, I was able to save as is a PDF file. That works. However, when I used the same approach for a Word file, using the marker:
   lnLocation=AT(Chr(208) + Chr(207) + Chr(17) + Chr(224) + ;
    Chr(161) + Chr(177) + Chr(26) + Chr(225),lcFile)
This creats a file that cannot be opened in Word.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform