Thanks, Razzak, but I'm already doing that and am looking for another way. I actually DO NOT want to load the picture into the database, I just want to stick it in a variable from an outside file. John gave me some tips today but I am too dumb to figure it out. I suspect a large DUH donation at the conference from me...I KNOW there is a way to do this. Here is what I want to do: Have a number of jpg files in a directory. In a form or report, display those files as they associate with field contents. For example, if I have a text field with the name "John Smith" in it, I want to display a picture on the form or report that is named "john Smith.jpg" from either the same directory or a sub directory. I'm sure I saw this somewhere! If not, I'll go back and do it the hard way.......
Also, You are right about the myriad of tools in the Blob Viewer / Editor, and some work pretty well, but have you actually tried to CROP an image? There is a convoluted method where you have to click on the mouse control and got through several steps to do it. It works but it is not like other graphic editors, where as ou hit a crop control once and a dotted square comes up with adjustment handles over your image. In this tool, it takes too many steps, and in my particular upcoming instance, I have to do this 500 times in one day...daunting. Thanks in advance Bob C -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Wednesday, September 07, 2005 3:27 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Pictures to a DB At 10:54 PM 9/6/2005, Bob Castanaro wrote: >... I totally forgot how to load a photo into a DB. I have essentially >a roster of names and addresses, and what I want to do is add a picture >of the person to forms and reports. I know there are several ways to do >this, and have used the method to load the pic right into the DB from >the BLOB viewer, but that is sort of limiting if you want to modify the >picture. I guess I just want to have a graphic field that will display >a graphic image file from the same directory or a sub-directory of the >program, but have the image file out there for modifications like >cropping or brightness. I know there is an EASY way to do this.... Bob, While editing the data (Column with VARBIT data type) or using the form (DB Image), you can double-click on the field/control to bring up the built-in Note/BLOB Field Viewer/Editor. Among many cool features, the Note/BLOB Field Viewer/Editor also include the following features related to Image: . Rotate (90, 180, 270, Arbitrary) . Flip (Horizontal, Vertical) . Negative . Crop ... . Sharpen . Smooth . Brightness (Increase, Decrease) . Contrast (Increase, Decrease) . Edge Detection . Emboss . Gamma . Convert to Gray . Format Conversion . Resize ... If you want to automate the entire process you may use the "RBBEdit" command to achieve that goal and then use the INSERT or UPDATE command to load or update the BLOB data. Hope that helps! Very Best R:egards, Razzak.
