I save the files and reference them from the database. It is much easier, works well, is less AND tastes great!
John Harvey -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jack Skelley Sent: Wednesday, July 28, 2010 9:16 AM To: [email protected] Subject: RE: VFP - Image Editing OCX Good Morning Michael: The storing of bmp and jpg in general fields has never created any issues for me. I have written other apps for fun where I store the image file spec in a table and bring the image from the image directory when it is needed. I wrote a system to track my tomato cultivars in VFP 8 that stores the image on disk and will view the image when it is requested. But in the scouting system data is coming from all over the world and I wanted to keep the image stored in the table to cut down on the number files traveling across the Internet. Believe me I looked at all possibilities when I designed this subsystem in scouting. The big problem is data bloat in the general fields. I strip the JPG header from the file and store the bytes in the general fields. Then when the image is viewed I extract the data and add back the header. I also wrote a procedure to strip the bloat that runs every time the tables with general fields are updated from the scouts in the world. And they have a procedure to strip the bloat when they populate the table. If the table was to become corrupted that holds the general fields I have the tables backed up in multiple locations and have a job that runs every evening to populate the backup sites. If all those tables are corrupt I also have procedures in place that I can get the data back from the individual scouts and rebuild the master table on the server. Luckily (so far), none of that had to be implemented. So basically I don't worry about it and performance is not an issue with the data in general fields (it is very fast). I really want the graphic editing to be in the system and have the look and feel of what was previously there so there are no other programs the scouts have to learn. I want them to spend their time finding a left wing who can put the puck in the net instead of me being on the phone and/or on their machine with log-me-in teaching them how to do what's new in the system. If I had an OCX I could probably make it work similar to what was previously in the system. Thanks for your input. Regards, Jack ________________________________________ From: [email protected] [[email protected]] On Behalf Of Michael Madigan [[email protected]] Sent: Wednesday, July 28, 2010 2:40 AM To: [email protected] Subject: Re: VFP - Image Editing OCX I've always heard that storing graphics in general fields was a big no no because of the instability of the database and the vulnerability to corruption. A better solution is to save a file name and path to the graphic file. It should also provide better performance. That being said, I would think you should be able to use any graphics program unless you really want it to be embedded in a form. [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/007201cb2e64$0aed9220$20c8b6...@[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
