Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
CursorAdapters and VARCHAR(MAX) columns in SQL
Versions des environnements
Network:
Windows 2003 Server
I ran across an issue today creating a cursor adapter. I wanted to map a datetime in SQL to a date in VFP, so I checked the box in the builder to "Use CursorSchema when filling cursor" and clicked the "Build" button to get the default schema. I changed my T column type to a D and then moved on to the Auto-Update tab of the Builder where I got the following error dialog
---------------------------
CursorAdapter Builder
---------------------------
An error occurred in this builder. The details are:
Error #: 1713
Message: Field width or number of decimal places is invalid.
Line #: 0
Method: OMEMBER.getfieldslistfromschema
Would you like to close the builder?
---------------------------
Yes No
---------------------------
Turns out that one of the columns is a VARCHAR(MAX) - something new in SQL Server and VFP doesn't like it much. The "Use memo when character field length greater than __" setting doesn't help.
I manually changed the C(255) the builder put in for me to M and life was good again.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement