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:
01475177
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.

Thank you. I will try that. But I wanted to be sure that the length of the UpdateNameList was not causing the issue.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform