ImgEdit display via SQL - urgent
Posted on 2002-03-21
I'm trying to use the imaging control on a vb form. I can get the control to work via a fixed file location ie(C:\test.gif"). However I want the source to be a BLOB from a SQL database.
This is what I have so far.......
objRS.Open "SELECT Data FROM Test", cnxn, adOpenKeyset, adLockOptimistic
mstream.Type = adTypeBinary
frmControl.ImgEdit1.Image = mstream.Read
But it errors out........on the mstream.read line
Is this possible or do I have to write the file out, use it and then delete it?
Any help would be appreciated.
PS These are all the points I have available