General information
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
CursorAdapters and VARCHAR(MAX) columns in SQL
Environment versions
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.
Next
Responder
Visualizar o mapa desta thread
View the map of this thread starting from this message only
Visualizar todas as mensagens desta thread
Visualizar todas as mensagens desta thread a partir desta mensagem