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~VFPYou will find tehre some words about your topic.
>How is a SQL Picture 'field' translated (ADLONGVARBINARY) to a DBF Picture field?
>Thanx
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.