>Is it safe/stable to store JPG files in a general field or should I stick to storing the path to the file???
>
>This is my first attempt to automate the storage and management of digital photos (JPG's). I have the need to store 4 photographs for each of the 50,000 defendants in our database. Before I do this I would like to here from someone out there who has experience in this area. I have never used General Fields in a VFP Table before and I have read some disturbing things concerning them (Size/Stability Issues).
If you're already storing paths/names, I'd stick with that. Corruption of memo files (it does happen from time to time ;-)) could cause big problems. Also servers prefer pushing around small JPEGs rather than massaging an immense .FPT.
I'd also recommend not storing too many images in any one folder, as this can also slow down access on a server. Work up a structured series of folders to hold the images.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up