>>>>Hi,
>>>>
>>>>I am working on troubleshooting a rather rare case where a customer get an error on Tableupdate(). The error is generated and logged in but all it shows the a unique index key is violated. I need more information such as actual content of the cursor that failed. I can create a routine to scan the records of the "faulty" cursor and include in the error. So my question is, does VFP change anything in the cursor if the Tableupdate() fails?
>>>
>>>No, if tableupdate fails, the cursor will be as it was before tableupdate (although the same is true otherwise as well). The table is not changed if tableupdate fails.
>>
>>This is good. So hopefully by checking the content of the cursor I will get to the bottom of the issue. Thank you.
>
>probably too late - but as you are keen on learning new things and twitches,
>for such cases the hooks in the cursoradapter class fired before and especially AFTER
>updating/deleteing/inserting of each record of the client cursor make this much easier.
>You find out which records barf by inserting code to run when the result-parameter is false...
>
>regards
>
>thomas
Excellent suggestion. Thank you very much.
"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