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


> 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)

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