Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to control the contents of a Pass-through query
Message
From
28/08/2007 19:17:53
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01251005
Message ID:
01251052
Views:
18
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform