Attaching document or image to a record

Post Reply
User avatar
cdmmaui
Posts: 653
Joined: Fri Oct 28, 2005 9:53 am
Location: The Woodlands - Dallas - Scottsdale - London
Contact:

Attaching document or image to a record

Post 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,
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
ukoenig
Posts: 3981
Joined: Wed Dec 19, 2007 6:40 pm
Location: Germany
Contact:

Save Image-name to Database

Post 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:
Since 1995 ( the first release of FW 1.9 )
i work with FW.
If you have any questions about special functions, maybe i can help.
User avatar
cdmmaui
Posts: 653
Joined: Fri Oct 28, 2005 9:53 am
Location: The Woodlands - Dallas - Scottsdale - London
Contact:

Post 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.
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
ukoenig
Posts: 3981
Joined: Wed Dec 19, 2007 6:40 pm
Location: Germany
Contact:

Dokument-handling

Post 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:
Since 1995 ( the first release of FW 1.9 )
i work with FW.
If you have any questions about special functions, maybe i can help.
User avatar
cdmmaui
Posts: 653
Joined: Fri Oct 28, 2005 9:53 am
Location: The Woodlands - Dallas - Scottsdale - London
Contact:

Post 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,
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
richard-service
Posts: 583
Joined: Tue Oct 16, 2007 8:57 am
Location: New Taipei City, Taiwan
Contact:

Post 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
Post Reply