Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to control the contents of a Pass-through query
Message
De
28/08/2007 19:17:53
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01251005
Message ID:
01251052
Vues:
16
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform