data in memo field extract??

[e***@hotmail.com]

Hi All,
I have never in my life used VFP before, but have been working alot
with databases.
I have no contact with the man who originally developed this DB, and
actually am going to move it all to MS SQL soon.

I just got a DB in VFP, with a table that includes a MEMO field. (I
think the database was created in VFP 7, i am using VFP 9 to view it).
I know this field contains images, although i am not sure what type
they are in. The data starts with LTRI , and i can guess it either a
PNG format of PCX format. Only guessing.
Is there any way to extract that data and make an image file from it?
Is there any way for me to know what image format it is in? Does it
include a container, like MS ACCESS OLE images, that needs to be
extracted??
Thank you in advance.
Eli Gur

[Stefan Wuebbe]

Hi Eli,

Sounds as if the images were originally inserted using VFP's
FileToStr() function. If so, it was a good idea not to use "general
fields" (OLE), and you might be able to re-create the original
files using the opposite StrToFile() - e.g. in pseudo code:
Select 0
Use yourtable Again Alias someAlias
Scan
cFileName = Sys(2015) && or the original name read from another field?
StrToFile( someAlias.theMemoField, m.cFileName )
EndScan


hth
-Stefan

(Please do not crosspost)
--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------

Post by e***@hotmail.com
Hi All,
I have never in my life used VFP before, but have been working alot
with databases.
I have no contact with the man who originally developed this DB, and
actually am going to move it all to MS SQL soon.
I just got a DB in VFP, with a table that includes a MEMO field. (I
think the database was created in VFP 7, i am using VFP 9 to view it).
I know this field contains images, although i am not sure what type
they are in. The data starts with LTRI , and i can guess it either a
PNG format of PCX format. Only guessing.
Is there any way to extract that data and make an image file from it?
Is there any way for me to know what image format it is in? Does it
include a container, like MS ACCESS OLE images, that needs to be
extracted??
Thank you in advance.
Eli Gur