Hi!

Assuming you're talking about image field at the SQL Server, query to image field in the SQL Server returns result with General field. However, it is quite hard to work with and maintain general fields in application. They're also quite slow and not portable, not reliable etc.

For any binary data in our applications I used another approach. It is tricky, of course, but much more reliable and usable.

We store images and other files (word documents, ZIP archives, any other binary data) in teh image field at the SQL server as is. This means we use Memo field at the VFP client side to work with these data. VFP is very hard to convert image field into memo, however, this could be done. For case when you use remote views, MS recommends in its articles to use field type cnvertion by specifying field type directly in the properties for field in view (change general to memo). See articles Q145991 and Q245714 in MSDN library.


For SQL Pass-through cursor I investigated the way for converting by self. It might be slower than remote views because extra copy of data. See following link for sample code:
http://www.tek-tips.com/gthreadminder.cfm/lev2/4/lev3/27/pid/184/qid/28024.

Look also to article
http://fox.wikis.com/wc.dll?Wiki~MoreOnRemoteViews~VFP

You will find tehre some words about your topic.

>How is a SQL Picture 'field' translated (ADLONGVARBINARY) to a DBF Picture field?
>Thanx