Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Vladimir Zografski
  Where is Vladimir Zografski?
 Sofia
 Bulgaria
 Vladimir Zografski
 To: Sushil Agarwal
  Where is Sushil Agarwal?
 pune
 India
 Sushil Agarwal
 Tags
Subject: RE: Jpg Image View
Thread ID: 155103 Message ID: 155120 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Tuesday, December 25, 2007 11:10:26 AM         
   


> >
> > Sushil,
> >
> > If you have a small number (a few hundred) of small images, they you can use FILETOSTR() and store them in a blob field:
> >
> >
> > REPLACE MyBlobField WITH FILETOSTR(FULLPATH(lcMyImageFile)) IN MyTable
> > 

> >
> > The thing to watch for is the 2 GB limit. Files associated with a VFP table (DBF, CDX, IDX, FPT) can not exceed the 2 GB limit. For this reason, most developers will store only the path and file name, but there is another option. Take a look at my FAQ here:
> >
> > https://www.foxite.com/faq/default.aspx?id=26
> >
> > Ken
> > You shall know the truth - and the truth shall set you free. (John 8:33)
>
>
> Thanks Ken,
>
> for the information about 2gb limit, i must think better to keep file in jpg files as you suggested.
>
> but what i wanted to know why the IMAGE USING PICTUREVAL (BLOB) METHOD WAS not shown, how to be confident that jpg file stored using filetostr will show the image on form
>
> S.N.Agarwal


ThisForm.image1.Stretch = 2 
ThisForm.image1.PictureVal = MyTable.MyBlobField



Vladimir Zografski
Systems Analyst

ENTIRE THREAD

Jpg Image View Posted by Sushil Agarwal @ 12/24/2007 7:19:07 PM
RE: Jpg Image View Posted by Ken Murphy @ 12/24/2007 9:24:00 PM
RE: Jpg Image View Posted by Sushil Agarwal @ 12/25/2007 5:58:16 AM
RE: Jpg Image View Posted by Vladimir Zografski @ 12/25/2007 11:10:26 AM