Jack, Personally I would steer clear of the General fields as if the ever do get corrupted you have totally screwed your data and either use the direct link as you suggest or actualy convert the source file to binary data and store in a memo field. When you need to view the file then extract it (strtofile() and filetostr()) creating a temporary file and then processing it.
I use this technique on SQL Server and it works well. The big bonus is that you know exactly where the data is i.e in the database as opposed to in a folder somewhere that can be moved/corrupted etc. The only reason to not do it this way is the real possibility of busting the VFP tible size limit and that is why I went the SQL Server route as SQLExpress now has a 10gb limit. I have only glimpsed at WIA and can't really comment on its suitability. Dave C -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jack Skelley Sent: 27 July 2010 22:54 To: [email protected] Subject: VFP - Image Editing OCX Good Afternoon All: Back in the day when Windows 2000 was the operating system for our scouting system I wrote (using the Kodak/Wang Imaging OCXs) a form that would allow the scouts to bring up a BMP of various rink configurations and allow them to edit the image. The editing consisted of showing passes, shots, power play setups, and other forms of hockey info. The OCX components of the Kodak/Wang image editor worked very well in places and was very buggy in others. But overall it worked great. Then XP Pro came out and the Kodak/Wang image editor was no longer included in the system. That was ok because the scouts that did the image editing no longer were required to do it and simple text entries were acceptable. So the page of the pageframe was disabled for edit the ActiveX objects removed and the code commented out. But the user could see previous edited BMPs that were stored in the general field of the table. There was a view but no new entries were allowed. Now things have changed again (new coach, etc.) and there is need to edit/annotate BMP rink images again. Images now also need to be imported into the table and annotated from the scout's Blackberry or camera phone. That part of it is under control (famous last words <g>) to get tjhe image into the table but it can't be annotated. Since the Kodak/Wang image tool is no longer part of Windows (XP or 7), I need a simple tool that will manipulate the BMP rink images or JPGs from the Crackberries / Cameras / or phones. I did some research and found that the old Kodak/Wang OCXs are available from Global 360 but they make no mention of the OCXs working in Windows 7. Is anyone editing images on a VFP form and saving them to a general field? If so, what are you using? Obviously there are some very pricey packages out there but I only need simple. Insert a line, text, etc. What does Windows Image Acquisition Automation Library do for image editing? I couldn't find any info and the VB6 examples didn't work. Thanks for any insight. Best regards, Jack Skelley [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/[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.
