FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour How to Store Images in MDB Table using FWH ?
Posts: 654
Joined: Fri Oct 21, 2005 05:54 AM
How to Store Images in MDB Table using FWH ?
Posted: Sat Apr 08, 2006 03:06 AM

Hi

Can anybody guide me: How to store images in MS Access Table
Fields like the way we store images in .FPT file using FWH ?

Thanks in advance

  • Ramesh Babu P
Posts: 99
Joined: Wed Nov 02, 2005 10:40 AM
Re: How to Store Images in MDB Table using FWH ?
Posted: Tue Apr 11, 2006 01:34 PM
RAMESHBABU wrote:Hi

Can anybody guide me: How to store images in MS Access Table
Fields like the way we store images in .FPT file using FWH ?

Thanks in advance

- Ramesh Babu P


As i know, the problem is that you can do this only with DAO and not ADO.With ADO you can store large amount of array byte inside an OLE field but access will not recognize it as Image.

Regards
A.S.K
Posts: 189
Joined: Mon Nov 07, 2005 07:36 PM
How to Store Images in MDB Table using FWH ?
Posted: Tue Apr 11, 2006 03:33 PM

( sorry for my english )
I use a neanderthal tecnique:
1. read the bitmap ( or other format )
2. transform to text with base64
3. in base64, is text; simple to store in any field of varchar o variable length.

For display, the process is the same but in inverse order.

I hope serve to you
Bye.

Julio Gonzalez V.

RANDOM S.A.

SISTEMICA S.A.
Posts: 654
Joined: Fri Oct 21, 2005 05:54 AM
How to Store Images in MDB Table using FWH ?
Posted: Wed Apr 12, 2006 01:52 AM
Hi dbzap


1. read the bitmap ( or other format )
2. transform to text with base64
3. in base64, is text; simple to store in any field of varchar o variable length.

For display, the process is the same but in inverse order.


Can I get a small working sample please.

Thanks to ask and dbzap

- Ramesh Babu P
Posts: 99
Joined: Wed Nov 02, 2005 10:40 AM
How to Store Images in MDB Table using FWH ?
Posted: Wed Apr 12, 2006 10:11 AM
dbzap wrote:( sorry for my english )
I use a neanderthal tecnique:
1. read the bitmap ( or other format )
2. transform to text with base64
3. in base64, is text; simple to store in any field of varchar o variable length.

For display, the process is the same but in inverse order.

I hope serve to you
Bye.


This is the know way BUT you can not see the image from ACCESS.If this does not bother you then you don't have any problems.

Regards
A.S.K

Continue the discussion