Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which Date Type in SQL Server?
Message
 
 
À
01/05/2018 15:43:25
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., Nouvelle Zélande
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01659629
Message ID:
01659673
Vues:
56
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform