General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only