image within a blob field

[Jerim65]

I am using a table created by a 3rd party application.

One of the tables has an ole_object blob field which contains either a link to an external file or the contents of a file which may be an image, doc file, worksheet etc.

I am able to find the file/path of a linked file and am now trying to identify and recreate an embedded file out to disk.

Has anybody any code to tease this out of a blob field?

Thanks Coldan

 

[Olaf Doschke]

blob in a dbf? Or is this rather a general field? How is it shown in a browse? "Gen"? Then it's not a blob field.

If it's a blob field you can simply do strtofile(blob,"filename") (see

http://fox.wikis.com/wc.dll?Wiki~BLOB)

or COPY MEMO blob TO "filename", a blob just stores the file 1:1 binary, what you describe, especially with the alternative to store a link to a file is true for e General field.

In both cases you need to know the file/picture type. In case of a general field to read from it and store the file to disk as an external file is only possible using hacks, eg via the reportlistener:

http://support.microsoft.com/kb/894819/en-us

Bye, Olaf.

 

[Jerim65]

Olaf,

Please pardon my confusion - they are indeed in a General field.

I have the 'linked' conversion part of the process working and will investigate what you have given me here.

Many thanks.

Regards

Coldan