Click here to Skip to main content
15,937,127 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I am having a table student with one field pics of data type BLOB.

Now I want to perform operations add/delete/modify on table but I don't know how to deal with BLOB because I haven't any idea about this data type.

One important thing is picture needs to be inserted using vb6.

I tried some very poor code for it like:

<br />
Private Sub IMAGE()<br />
Dim FILE As String<br />
FILE = App.Path 'path_name'<br />
If Picture1.Picture = Empty Then<br />
Open FILE For Binary Access Read As #1<br />
Get bytes<br />
rs("pics")<br />
<br />
End If<br />
End Sub<br />
<br />

Can you please help me.........
Updated 22-Jan-13 20:37pm
Sergey Alexandrovich Kryukov 23-Jan-13 2:40am    
Any specific reason to develop anything in VB6? :-)
surkhi 23-Jan-13 3:01am    
That is my managers requirement........

1 solution

Share this answer
surkhi 23-Jan-13 3:00am    
As I seen the second links,I am not having pictures already stored in database....
I just have pics empty field with blob data type...
Is that code useful for me???

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900