Click here to Skip to main content
12,299,315 members (54,008 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB6 Oracle
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:

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

End If
End Sub

Can you please help me.........
Posted 22-Jan-13 20:35pm
surkhi623
Edited 22-Jan-13 20:37pm
v2
Comments
   
Any specific reason to develop anything in VB6? :-)
—SA
cool_sari 23-Jan-13 3:01am
   
That is my managers requirement........

1 solution

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

Solution 1

  Permalink  
Comments
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 | Mobile
Web02 | 2.8.160525.2 | Last Updated 23 Jan 2013
Copyright © CodeProject, 1999-2016
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