Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CA error on update
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01475166
Message ID:
01475171
Views:
24
>>>Hi,
>>>
>>>I get error when updating a CursorAdapter cursor. The error says
>>>
>>>Insufficient column information for updating or refreshing
>>>
>>>
>>>I checked and it looks like the value assigned to the keyFieldList is correct. What else could be causing this issue? I also noticed that the value of my UpdateNameList property is fairly long (1508 characters); could it cause the error shown above?
>>>
>>>TIA.
>>
>>Is it CA for SQL Server? If yes, did you try checking if a command being send to SQL Server and what is this command (using SQL Profiler)?
>
>Yes, it is CA for SQL Server. And I don't know how to use SQL Profiler; will have to search for newbie article.

Simply invoke it from the Tools menu and then Run a trace. For now, nothing else is required. Although if you're running SSRS there will be too much extra stuff in the trace and you may want to filter by the application.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform