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:
01475181
Views:
21
>>>>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.
>
>For a quick test, you can leave only few fields in that list and re-test.

I think I found the problem. The column that I was "using" as a PK is not really set as PK in the database.
"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