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.
