Dick, Many of the programs I write include the viewing/printing of photos not loaded into the database.
You would have to add columns into you product table that references the source directory and the name of the photo file. Also create a computed column that combines these 2 columns. Example: Table=Products Add these columns: Column=PhotoDir (text, 60) Column=PhotoName (text, 20) Column=Photo (text, 80) computed (PhotoDir+PhotoName) Add these fields to your product form(or not) and fill them in. The methods available to you to load these columns are: 1. Manually enter the data through the data browser or the product form. 2. Use plugins to locate the directory and image file (which I prefer) Rbase 7.5 has the capability to show variable images. In your product form locate a variable image. The variable would be something like this; Vphoto(text)=Photo. Stretch the field to suit your needs and available space. Right-click on the variable image and check the boxes for Center, Stretch and Proportional. You could also; 1. Add a button which launches the photo(opens in photo editor or Paint, as in Larry's example) 2. Create a separate form which you would size for a larger image within the product form. You would either use an eep in the variable image or place a button to view the larger photo. (ex.browse using LargePhoto, the same variable(vphoto) and variable image placed on the form) Hope this helps. Bill Eyring -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Tuesday, December 21, 2010 10:04 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Calling outside files We currently keep pictures of the products we sell in our DB as small varchars and it works very well. Now we are thinking of keeping some other pics that need to be much larger resolution. I know I have seen discussions on this list concerning keeping larger files outside the database. How do you call those files from within R:Base? Currently using 7.5 Thanks and Happy Holidays to all on this list. You are all so helpful, it is truly a blessing to be a part of it. Dick Fey Carpet Broker Inc. Lenexa KS --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
