Hi Gary, I assume that you are actually storing the images in the table itself? If so I would advise against that. It is better to store the images themselves on the disk and just refer to the file rather than copying the image into the table. Dealing with general fields in VFP isn't great. So either use a naming convention for the image names (for example I would name the image the same as the primary key from mytable) or store the path to the image in a memo field and use that to refer to the image.
Hope this helps, Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit from our services, please contact me. We would appreciate the opportunity to work with them. On 11/03/2010 12:48 PM, Gary Jeurink wrote: > I have a movie and music database that have evolved into larger than > expected size. Recently I reorganized and added an instance table to both as > I have acquired multiple copies of things... DVD, VHS, ... ALBUM, TAPE, CD, > M3 and so on. I also keep a table of music artists with bio and photo , > albums with photo& info. Occasionally artist table, the photo field gets > corrupted somehow two records will contain the same photo... ??? of course > one being wrong then... > > I have considered making a separate table for the photo's to make searches > views and forms quicker to develop. For example, I did this in music making > a separate table for lyrics so multiple songs can share the same lyrics and > the majority of the music instances (that have no lyrics) can point to a > memo field that reports 'no lyics available'. > > In a photo table I could make an image 'NO PHOTO AVAILABLE' in the table > for the many instances when the field has no data. > > If you follow what I'm doing, am I on the right road or is there a better > way. > > Gary the grateful rookie > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
