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?
 Ken Murphy
 To: Sushil Agarwal
  Where is Sushil Agarwal?
 Sushil Agarwal
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


If you have a small number (a few hundred) of small images, they you can use FILETOSTR() and store them in a blob field:


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:


You shall know the truth - and the truth shall set you free. (John 8:33)


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