>>>Hi Kids!
>>>
>>>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).
>>>
>>>Got any ideas??
>>>
>>>Hugh
>>
>>Now you see the reason that General fields are not recommended usage, it's pretty easy to get things into them, but pretty tough to get it out!
>>
>>I'd recommend you use a binary memo field instead.
>
>Well, I'm not sure I can convert general field data from a SQL Server database into binary memo field data without losing the data. I tried and that's what happened.
>
>Do you have any ideas on how to convert the data from general to binary memo without losing it?
>
>Hugh

Not if it's already in the general field. If it's coming from a SQL Server data source, redefine that field in your view to be a binary memo instead of a general, so it will be brought down in a usuable format.