Hi Ken,

Nice to hear from you.

I actually just figured it out on my own. The deal is that there is an SQL Server table with a BLOB field that holds various types of image files. Luckily there is also a field in the same row that tells you what kind of image file it is.... anyway, when I created a remote view of the table from within VFP the query builder wanted to see that field as a general field but since there was no link information embedded in the file it couldn't be opened.

What I did was reconfigure the remote view to the table and change that field to a binary memo field type. That allowed me to run a STRTOFILE() on it to a file of the filetype extension designated. Once I did that I could double click on the file and open it up.

Problem solved!

Hugh

>>Does anyone have any idea how to get the data out of a GENERAL field and into file.
>>
>>I've already tried setting a memory variable to the value of the GENERAL field (this throws an error) so I can't then do a STRTOFILE on it. One possible complication is that the data comes from a remote view of a SQL Server table. I already tried copying a row of the table to a real VFP table and that didn't seem to help. Also the data in the field is of varying types (ie; GIF, JPG, BMP).
>
>Hi Hugh! I'm not certain, but this KB article may be able to help you find a solution:
>
>How to export pictures from General fields by using the ReportListener base class in Visual FoxPro 9
>http://support.microsoft.com/kb/894819/EN-US/