THANKS!!!!!!! IT WORKED LIKE A CHARM.
bob
>You have to map SQL Image column to VFP Blob by issuing once before SQLEXEC()
>
>CURSORSETPROP("MapBinary", .T., 0)
>
>
>>I have a query I submit through SQLEXEC() that creates a cursor.
>>
>>I'm taking the results and placing them into a local foxpro table for offline use. This has worked just fine for years, but now I've added an image column in the SQL data table holding pictures, and I want to be able to take those pictures offline too.
>>
>>When I run my query, it creates a General field in the cursor (from the image column) which is worthless. I can't modify the table without lossing the pictures, and they won't display like a Blob field will. So, here's my question. How can I get Foxpro to return a Blob field in the cursor?
>>
>>Thanks.
>>
>>Bob Bartel