Attaching document or image to a record

Attaching document or image to a record

Postby cdmmaui » Thu Oct 30, 2008 11:42 pm

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
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Save Image-name to Database

Postby ukoenig » Thu Oct 30, 2008 11:59 pm

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
ukoenig
 
Posts: 4043
Joined: Wed Dec 19, 2007 6:40 pm
Location: Germany

Postby cdmmaui » Fri Oct 31, 2008 12:06 am

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
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Dokument-handling

Postby ukoenig » Fri Oct 31, 2008 12:24 am

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
ukoenig
 
Posts: 4043
Joined: Wed Dec 19, 2007 6:40 pm
Location: Germany

Postby cdmmaui » Fri Oct 31, 2008 2:13 am

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
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Postby richard-service » Fri Oct 31, 2008 3:37 am

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
User avatar
richard-service
 
Posts: 803
Joined: Tue Oct 16, 2007 8:57 am
Location: New Taipei City, Taiwan


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 93 guests