|
Home > Archive > FoxPro database connector > August 2005 > data in memo field extract??
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
data in memo field extract??
|
|
| eligur@hotmail.com 2005-08-08, 7:25 am |
| 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 2005-08-08, 7:25 am |
| 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
-----------------------------------------------------------
<eligur@hotmail.com> schrieb im Newsbeitrag
news:1123495932.653992.226170@g43g2000cwa.googlegroups.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
>
|
|
|
|
|