Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Force SPT cursor with varchar fields
Message
De
10/12/2016 02:42:30
 
 
À
09/12/2016 18:13:03
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:
01644790
Vues:
79
This message has been marked as the solution to the initial question of the thread.
J'aime (1)
>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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform