Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Oct 1, 1996

Retrieving Binary Objects

Question:
I am using VB together with Access. What I want to do is to include photo into my form. In Access table, I declare this field as an OLE field and in VB I use a Picture Box. My problem/question is that VB recognize longbinary while Access recognized Bitmap. But I want both application to be able to extract my picture file. So there should be two step, one is to convert from Access(Bitmap) into long-binary in the program. Second is that when I select a photo from Commond Dialog I could be able to save back into Access. So there should be another conversion.

Answer:
Take a look at the GetChunk function (and related functions such as AppendChunk). That's the function that is used to extract the blob into a variable/control.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date