FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Attaching document or image to a record
Posts: 708
Joined: Fri Oct 28, 2005 09:53 AM
Attaching document or image to a record
Posted: 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
Posts: 4043
Joined: Wed Dec 19, 2007 06:40 PM
Save Image-name to Database
Posted: 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.
Posts: 708
Joined: Fri Oct 28, 2005 09:53 AM
Attaching document or image to a record
Posted: 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
Posts: 4043
Joined: Wed Dec 19, 2007 06:40 PM
Dokument-handling
Posted: 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.
Posts: 708
Joined: Fri Oct 28, 2005 09:53 AM
Attaching document or image to a record
Posted: Fri Oct 31, 2008 02: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
Posts: 866
Joined: Tue Oct 16, 2007 08:57 AM
Attaching document or image to a record
Posted: Fri Oct 31, 2008 03: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
Best Regards,



Richard



Harbour 3.2.0dev (r2503251254) => Borland C++ v7.7 32bit

MySQL v8.0

Harbour 3.2.0dev (r2503251254) => Borland C++ v7.7 64bit

Continue the discussion