Mike: I have an application similar to yours where the pictures (highway inventory items including signs, bridges, roads, etc) are stored in subdirectories rather that in the database. I have a database table that stores picture information, such as location, date and picture file location and name. I use a form with drop down fields so the user can drill down to a set of pictures from which the user can select one. I have two push buttons in the form "DISPLAY PHOTO" and "LAUNCH PHOTO" If the user chooses the first option, an EEP opens a form that displays the photo as well as the photo information; this second form has a push button "PRINT PHOTO" which starts an EEP that prints a report with the photo and its corresponding information. If the user selects "LAUNCH PHOTO" in the first form, the application "launches" the photo using the default viewer (Microsoft Photo Editor, in my case) The advantage of this approach is that the user can view the picture and print a nice report that includes not only the photo but also the stored photo information or he can open the photo for viewing/editing using his preferred photo editor/viewer. The EEPs are very simple and just a few lines long.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On Behalf Of mjs Sent: Thursday, October 17, 2002 5:12 PM To: [EMAIL PROTECTED] Subject: RE: Working with BLOBS and FORMS Troy, Which viewer do you use? Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com] On Behalf Of Troy Sosamon Sent: Thursday, October 17, 2002 5:29 PM To: [EMAIL PROTECTED] Subject: RE: Working with BLOBS and FORMS Mike, Personally, I would open the image in another window using a third party viewer. You could open your R:base form and the other viewer window at the same time and view your image and type in your other info in the R:base form. Troy ===== Original Message from [EMAIL PROTECTED] at 10/16/02 2:41 pm >Hi all (and especially Troy!) > >I finally got a scanner that works good enough to scan zillions of >documents, and get them sent to a subdirectory on a harddrive. Now I >want to look at the tif files, load their names into a table in Rbase, >and >have this table have a few extra columns for other info about the >individual files. I made a form that has just 1 variable in it called >vtif. I set the value of vtif as follows.... >SET v vtif = ['filename.tif'] > >Then I want to look at my nice new tif file in Rbase.... > >EDIT USING formname. > >But all I see is the upper left hand corner of the file! How do I >"squish it" in Rbase so I can see the whole file? If I use an external >viewer that does that, then how do I use Rbase to add more data about >the file to the table that has the filenames listed? Do I have to use >Rbase to call the external viewer and then go back and forth? >HELP! > >Mike Sinclair > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
