>>>>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