Message
 
To
Todo
General information
Fórum:
Visual FoxPro
Category:
Bases de dados, Tabelas, Views, Indices e SQL
Título:
CursorAdapters and VARCHAR(MAX) columns in SQL
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
ID da thread:
01321461
ID da mensagem:
01321461
Views:
130
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
Mapa
View