What we do here is store the our delivery pictures in a folder on the server and then add the path to that picture to the data using the ShippingID as the link to all the pictures. I have a Variable Image control in a scrolling region that displays all the pictures to that shippment. I also have used a temp table that gets setup in on click part of combo box
PROPERTY TABLE tShippingImages CLOSE PROPERTY RBASE_FORM_ACTION tShippingImages '' APPEND ShippingImages TO tShippingImages + WHERE ShippingID = .vShippingID + ORDER BY ImageID ASC PROPERTY TABLE tShippingImages OPEN RECALC VAR And a form variable vImagePath = ImagePath and this gets asigned to the Variable Image control. Victor Timmons Tiz's Door Sales, Inc Visit us at www.tizdoors.com P Please consider the environment before printing this e-mail -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Friday, July 01, 2011 8:39 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Storing pictures outside the database Using 9.1, latest build. Our product photo database is growing and starting to slow things down. We have found that having pics of all our products instantly available would be very helpful. Therefore we are looking at putting all 8000 of our product pics on file. I know I have seen discussion on this board about storing jpeg's outside the database, but cannot remember how to access the archives. I assume you just store the address in the database, and call the jpeg from the outside file as needed. Any tips on doing this in the most efficient way, particularly regarding how to load them into a form viewer would be appreciated. Thanks, Dick Fey Carpet Broker Inc.
