Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapters and VARCHAR(MAX) columns in SQL
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Thread ID:
01321461
Message ID:
01321461
Views:
118
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
Map
View

Click here to load this message in the networking platform