Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Force SPT cursor with varchar fields
Message
From
10/12/2016 02:42:30
 
 
To
09/12/2016 18:13:03
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01644783
Message ID:
01644790
Views:
78
This message has been marked as the solution to the initial question of the thread.
Likes (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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform