July 23, 2002 at 4:08 am
can anybody help?
I try to store a jpeg file from VB into SQL 2000 server's image column.
After that, i can see the hex value from that column.But when retrieving back to VB and assign this field value to a image object's picture property, it hit error
July 24, 2002 at 5:51 pm
You can post some code here so we can see what's wrong.
--
-oj
Rac v2.1 Public Beta RELEASED.
July 25, 2002 at 2:30 pm
Thank for your replied. I'm a newbie for SQL Server.
I create a fieid using imgae data type
For example, the field name is "Photo"
From VB i save a jpeg file from image object
the code like
"myRs.filed("Photo").value = image1.picture"
I wonder whether the jpeg really stored into the database, since i can see a hex value only.
I tried to retrieve it back and show on the image object. The code as
image1.picture = myRe.Field("Photo").value
an error prompted out, said "Type Mismatch"
Should i use ADO's stream object to handle picture ?
Thank
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply