Hello

This question has probly been asked & answered before, so please forgive me
in advance.

I use a dbf file which has a general field in which I store photographs.
These are stored separately in a .fpt file which has the same name as the
database. I have noticed that apparently there is a 2 gigabyte limit on this
file. If this limit is reached within the runtime exe profram, the program
just does not add any more data - no error message id given. If trying to
append data from within development mode, a message something like "no more
disk space available" (not the exact words) is given, even though I have
plenty of space on the hard drive.

Is anyone aware of this problem and is there a work-around that doesn't
involve upgrading VFP?

Thanks
Mark Nixon

What most people do is not use general fields.
Use a text field to reference a filename and store your pictures as jpg's (or
gifs, tiffs, png, whatever)
Speeds up your database and will reduce your database size substantially

On Tue, 16 May 2006 14:02:47 +0930, "Jack Jones" <ajack100nospam (AT) hotmail (DOT) com>
wrote:


--- AntiSpam/harvest ---
Remove X's to send email to me.

Thanks Josh,

I had thought of that, but I am a compusively neat & tidy person and the
thought of literally thousands of jpeg files hanging around my computer is
somewhat daunting. I know that I can store them all in a separate directory
and back them all up separately to my database files, but it seems somewhat
messy.

I guess that is the only other option then. It seems odd to me that VFP
databases are supposed to be able to store an "unlimited" amount of records
when that is clearly not the case.

Anyway, thanks very much for your help.

Mark (Jack)


"Josh Assing" <XjoshX (AT) jAssing (DOT) com> wrote

FPT's are prone to bloat -- so unless you're packing regularly; you're wasting a
lot of space.

You could try compressing them, but jpg's are already pretty compressed....

you can store an unlmited number of RECORDS up to 2 gigs.

Every database has it's limitations. Want to be free of the 2 gig limit; use
MSDE -- it's free plays very nicely with vfp


--- AntiSpam/harvest ---
Remove X's to send email to me.

what you can do to (if you don't want to use MSDE) is to have more than one
table to strore your pictures with a parent table to use the right one for
the right picture (if your pictures are numbered, une a table for pictures
beginning with "0", one for "1", ....).

In my humble opinion, pictures need a lot of space and you will reach one
limit one day. Storing them in a FPT forces you to import them and then to
export them to see them. Leaving them as JPG in a directory allows you to
'browse' them with another tool as Photoshop or even Explorer. I'll go this
way ...

--
J. MAURICE @Grenoble.France.Europe UFPRC - Foxil

jsm.maurice wrote:
the number of files in the folder. There are pluses and minuses to any
method you choose, and you must choose the method that works best for
the situation you are in. There is no one best answer to this issue.

--
Cy Welch
89 Camaro RS 5.0 TBI
98 Passport
03 Malibu