Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Force SPT cursor with varchar fields
Message
De
12/12/2016 19:43:10
 
 
À
10/12/2016 02:42:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01644783
Message ID:
01644967
Vues:
62
>>I have a SQL Server stored procedure that I call with SQL Pass-Through. This stored procedure returns a different cursor depending on the value of the parameter and I would like to force all the character fields into varchar fields of all the cursors that stored procedure returns. I previously defined all character fields in the stored procedure as VARCHAR using the CAST() function.
>>
>>I tried with SET VARCHARMAPPING ON at the beginning of the application but it doesn't work,
>>
>>Can anybody help me?
>>
>>TIA
>
>begin every datasession
>
>=CURSORSETPROP("MapVarchar",.T.,0),CURSORSETPROP("MapBinary",.T.,0)
>
I put that in the Load() event of my form and it worked! Thank you very much.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform