Since I have multiple pictures per plant... How should I code each picture. I am thinking of putting a table of plant id./time stamp/... Maybe a location code (where in garden). The photo id.jpg will just be an incrementing number since it is just a way to locate it, right?
1. A goal is to be able to call up a spring / summer / fall picture of various plants. 2. Pull up a year to year photo of a plant to show growth Plant table Photo table Am I on the right track. Gary Jeurink -----Original Message----- From: Rafael Copquin [mailto:[email protected]] Sent: Saturday, May 15, 2010 12:40 PM To: ProFox Email List Subject: Re: garden slide show I have a few apps that show the product picture in forms and even in reports. There are thousands of pictures, so this is how I do it: a) store all pictures in a separate directory, for instance: c:\myapp\pictures b) the picture should weigh no more than 500 kb, so your screen would refresh quickly. However, larger sizes are ok. In my case, most pictures weigh less than 100 kb c) All pictures are JPG d) The picture name should have a unique association with the product code, for instance: product code 123456 picture code 123456.jpg e) you put an image control on your form and this is the code you should use to show the pictures ** in a navigate method of the form local cCode,cPath cPath = "c:\myapp\pictures\pictures\" && this is the folder where your pictures are stored cCode = products.code && pick up the product code from the cursor or table (products.dbf), as you navigate it thisform.image1.picture = cPath + alltrim(cCode) + ".jpg" ** the above would result in this string: thisform.image1.picture = "c:\myapp\pictures\pictures\123456.jpg" thisform.refresh In the above manner, as you navigate your products table, you can show the product's picture in the form. And because the JPG files are stored directly on the disk folder, rendering is very fast. DO NOT MAKE THE MISTAKE OF EVER STORING PICTURES IN A GENERAL FIELD. The file would grow enormously and it would be extremely slow to show the pictures. Hope this helps Rafael Copquin El 15/05/2010 0:56, Gary Jeurink escribió: > I started out 8-years ago with a plant/garden database to keep track > of plant/source, care, cost, location and so on. I have a general > field to store one 4 x 4 jpg photo of each. Now I want to log about > 1,000 plus photo's and sort them by date/plant/location. > > 1. be able to call a slide show per plant. > a. by time of year to show seasonal changes > b. year by year to show growth > 2. call up a slide show per vender > 3. map our garden and list plants per location > > As someone told me earlier, I should keep the photo's in jpg files and > track them by file name. > What strategy would any of you recommend. > > Gary Jeurink > > > --- 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/81413a2dde6149c7b2a4aa20443ae...@livingroom ** 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.
