Page 1 of 1

Attaching document or image to a record

Posted: Thu Oct 30, 2008 11:42 pm
by cdmmaui
What is the best way to attach a document or image to a database record. The actual document or image will be located in a folder, I would like to have an easy interface so user can double click on document or image, then the document or image filename will be stored to database field. Thank you in advance for your assistance.

Sincerely,

Save Image-name to Database

Posted: Thu Oct 30, 2008 11:59 pm
by ukoenig
Hello,

There is a nice sample TESTBMP.prg

There you can scroll from one BMP to the next.
You can add a save-button or choose leftdblclick on the image
to save the image-name to a dbf-field.

Regards
Uwe :lol:

Posted: Fri Oct 31, 2008 12:06 am
by cdmmaui
Hi Uwe,

That looks good, however I will need to handle PDF, TIF, JPG, BMP, XLS, Word, TXT and other formats. I would like to be able to select a file from a folder, then once the user selects the filename, a preview screen would show the actual document or image.

Dokument-handling

Posted: Fri Oct 31, 2008 12:24 am
by ukoenig
Hello,

I understand :

You want to handle Images / dokuments in both directions :
Store from image / document to DBF and show the image / dokument
from filename stored in a dbf-field ?
For images you have to add FREEIMAGE.dll to the working-directory.
With the DLL you can show the different image-formats.
Exel you can show from inside xBrowse.
Inside a folder-area, as far as i know, you can only show images and normal text.

Regards
Uwe :lol:

Posted: Fri Oct 31, 2008 2:13 am
by cdmmaui
Uwe,

Thank you, where can I get freeimage.dll? Also, is there a place where I can see an example of this DLL?

Thank You,

Posted: Fri Oct 31, 2008 3:37 am
by richard-service
cdmmaui wrote:Uwe,

Thank you, where can I get freeimage.dll? Also, is there a place where I can see an example of this DLL?

Thank You,
Hi cdmmaui,

check it below:

http://freeimage.sourceforge.net/

Regards,

Richard