Home » Infrastructure » Windows » How to display oracle BLOB image in VB6 ?
How to display oracle BLOB image in VB6 ? [message #241328] Tue, 29 May 2007 04:47 Go to next message
sunilraghavan_sunil
Messages: 1
Registered: May 2007
Junior Member
Hi,
I've a created a table(Oracle 9i(9.0.1.1.1)) as follows

CREATE TABLE PICT(ID NUMBER,IMG BLOB)

I inserted value 1 in ID and a jpg image named lotus.jpg ( it is in c:\image folder) in IMG field.

I'm using VB6 as front end. It contains an image box named img1 and a command button named cmd1. How can I display the image (lotus.jpg) in the image box from the table PICT by clicking the command button? I don't want to place any other controls other than the above said controls(image box and command button).

Thanks in advance,
Sunil
Re: How to display oracle BLOB image in VB6 ? [message #262640 is a reply to message #241328] Tue, 28 August 2007 00:00 Go to previous message
hasan_uiu
Messages: 18
Registered: August 2007
Location: Dhaka
Junior Member

you can try the followings

1. get the image from the table by a select quarry.
2.the quarry result store in a result set, so transfer the image to image control.. like this

resultset = execute result quarry
vb_image_control.set = resultset.get()

the above syntax are not exact so find the exact syntax for VB the idea is the same
Previous Topic: access denied
Next Topic: ORA-01565: error in identifying file '+DATA/asm/spfileasm.ora'
Goto Forum:
  


Current Time: Thu Mar 28 20:56:17 CDT 2024