Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to control the contents of a Pass-through query
Message
 
 
À
28/08/2007 16:28:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01251005
Message ID:
01251009
Vues:
24
This message has been marked as the solution to the initial question of the thread.
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
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform