Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Sushil Agarwal
  Where is Sushil Agarwal?
 pune
 India
 Sushil Agarwal
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: Jpg Image View
Thread ID: 155103 Message ID: 155111 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Tuesday, December 25, 2007 5:58:16 AM         
   


> > Hi Experts ,
> >
> > I am new to vfp, pl. help me
> > I want to store jpg images in vfp database, i read many articles on internet, i used general field and blob both
> > but after saving the images to table it does not show on form even by using pictureval ( Blob ), but if i give full file name and path of the image it can be seen on the form.
> >
> > if somebody changes the filename the image shown specific to a record will be wrong, so i want to store images in database preferably using blob field, can anybody help as how to do this. ( Images are in JPG Format)
> >
> > Thanks
> >
> > S.N.Agarwal
>
> 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

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