In a VB6 SQL 2000 application, I use an Image data type field to store .bmp file.
Is there a way to display the bmp file in a Picture object without having to save the file locally?
I know I can save the file somewhere using
Dim rs As ADODB.Recordset
Dim stmDocTest As ADODB.Stream
Dim strFile As String
Set stmDocTest = New ADODB.Stream
stmDocTest.Type = adTypeBinary
strFile = App.Path & "\TEMP\"
stmDocTest.SaveToFile strFile, adSaveCreateOverWrite
I would like to bind directly the Picture object to the Image data field without having to save the file locally
Set Picture1.Picture = rsDocument!docInsert (wich does work)
.... without having to save the file locally is my key issue