Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which Date Type in SQL Server?
Message
 
 
To
01/05/2018 15:43:25
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01659629
Message ID:
01659673
Views:
55
>>>We have varchar(max) columns coming OK through SQL Pass-Through. I think there is a setting needed for this, though.
>
>You can use CURSORSETPROP('MapVarChar', .T., 0) that (counter-intuitively) enables varchar mapping at the session level for subsequent selects... but still gets varchar(max) wrong. So unless your solution relies on the older non-native client ODBC drivers, I'm all ears!
>
>Meanwhile Remote Views have always allowed you to map fields including varchar(max) fields to memo, or you can cast to TEXT in your SQL that also does the trick.

Yes, that's the setting we use, I think. I know we use DSN and I haven't looked closely lately which driver we use.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform