Sergey,

I guess that's technically possible, but it seems highly unlikely as c_Store and c_MinMax are both cursors created from SPT. But, there are indeed indexes placed on them after creation, so I'll look into that.

Thanks,
Chad

>Chad,
>
>Maybe you got corrupted indexes on one of the tables?
>
>>I have a custom form method that issues the following UPDATE statement involving two cursors:
>>

>>UPDATE c_Store SET ;
>>		c_Store.nMin = c_MinMax.nMin ;
>>	FROM c_MinMax WITH (Buffering = .t.) ;
>>	WHERE c_Store.cGroup = c_MinMax.cGroup ;
>>		AND c_Store.lLock = .f. ;
>>		AND c_MinMax.nMin > -1
>>

>>This has been working fine, but today in testing it started causing this on a pretty regular basis:
><snip>
>>I don't see anything wrong with the query, but that's the line that keeps causing the problems. How do I even start to debug this?