Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: Badita Alexandru
  Where is Badita Alexandru?
 Bucharest
 Romania
 Badita Alexandru
 Tags
Subject: RE: Picture OleBoundControl
Thread ID: 232483 Message ID: 232494 # Views: 26 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Classes and Objects
Date: Tuesday, June 23, 2009 7:37:59 PM         
   


> I have MySql as back end I want to store picture of products/categories/people one picture each
> My question is what type of field is best suited for this and with what type of field do I map it in VFP(General/text etc) so it will not generate me an error when I tight the OleBoundControl to it?
>
> Intelligence reduces itself to making things easy even though they are complicated.

Stay away from General by all means. You either store a complete path\filename to the Pictures folder and use that with an Image.Picture object, or you store the file in a 'binary' Memo (NoCPTrans) or a Blob column and use he PictureVal property. See Help PictureVal

See alsos How to print pictures and how to display pictures that are stored in a Blob field in Visual FoxPro 9.0 at http://support.microsoft.com/kb/895602

-Anders



COMPLETE THREAD
Picture OleBoundControl Posted by Badita Alexandru @ 6/23/2009 5:39:09 PM
RE: Picture OleBoundControl Posted by Anders Altberg @ 6/23/2009 7:37:59 PM