Click here to Skip to main content
13,199,318 members (66,173 online)
Rate this:
Please Sign up or sign in to 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.........
Posted 22-Jan-13 20:35pm
Updated 22-Jan-13 20:37pm
Any specific reason to develop anything in VB6? :-)
cool_sari 23-Jan-13 3:01am
That is my managers requirement........

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

cool_sari 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.171020.1 | Last Updated 23 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100