Click here to Skip to main content
Rate this: bad
good
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 21:35pm
surkhi623
Edited 22-Jan-13 21:37pm
v2
Comments
Sergey Alexandrovich Kryukov at 23-Jan-13 2:40am
   
Any specific reason to develop anything in VB6? :-)
—SA
cool_sari at 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 at 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
0 OriginalGriff 8,284
1 Sergey Alexandrovich Kryukov 7,327
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,920


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 23 Jan 2013
Copyright © CodeProject, 1999-2014
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