Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Force SPT cursor with varchar fields
Message
From
12/12/2016 19:43:10
 
 
To
10/12/2016 02:42:30
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:
01644967
Views:
61
>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform