It won't. The file name is what they reference. Look at the file name of the image, and then see if you can find a match in the DB of that file name.
Least that is the only way I ever saw to make it work. -----Original Message----- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, April 02, 2015 2:42 PM To: ProFox Email List Subject: Re: [NF] MS SQL Server Image Data Type On Thu, Apr 2, 2015 at 2:33 PM, Jeff Johnson <j...@san-dc.com> wrote: > Thanks to Stephen and everyone for your help on SQL Server. The > databases restored very easily into the 2014 developer version. > > The challenge I have now is one of the tables stores images. There is > an image data type and I know if it is a pdf or a jpg etc. The image > field is a hex string representing the content. It does not match up > with a hex string of a pdf or anything else. Is there a way to view > the images or do you think they used a third party application to store the image? > ------------------ I have no experience from VFP in displaying an image stored in the db. Plenty associated with a .NET application or an SSRS report. That is found here http://www.lmgtfy.com/?q=tsql+display+image+stored+in+table -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/069001d06d7e$0e6e7050$2b4b50f0$@gmail.com ** 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.
