How to Store Images in MDB Table using FWH ?

How to Store Images in MDB Table using FWH ?

Postby RAMESHBABU » Sat Apr 08, 2006 3: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
User avatar
RAMESHBABU
 
Posts: 625
Joined: Fri Oct 21, 2005 5:54 am
Location: Secunderabad (T.S), India

Re: How to Store Images in MDB Table using FWH ?

Postby ask » Tue Apr 11, 2006 1: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
ask
 
Posts: 99
Joined: Wed Nov 02, 2005 10:40 am

Postby dbzap » Tue Apr 11, 2006 3: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.
User avatar
dbzap
 
Posts: 189
Joined: Mon Nov 07, 2005 7:36 pm
Location: Chile

Postby RAMESHBABU » Wed Apr 12, 2006 1: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
Last edited by RAMESHBABU on Wed Apr 12, 2006 3:03 pm, edited 1 time in total.
User avatar
RAMESHBABU
 
Posts: 625
Joined: Fri Oct 21, 2005 5:54 am
Location: Secunderabad (T.S), India

Postby ask » 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
ask
 
Posts: 99
Joined: Wed Nov 02, 2005 10:40 am


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 81 guests