>I previously ask about this problem and got some suggestion. I had to do some other tasks but can now get back to this problem. Background, VFP 7, multi-user, files are on a Novell server. There is an error handler but it is NOT triggered by update failures.
>
>The problem is that occasionally the 1st record of "n" records is not update. rest are (according to the user). Records are update individually. I need to force the update if it fails.
>
>The general structure of the code is
>
>SELECT vietms
>SET ORDER TO TAG ordkey IN vitems
>
>SEEK table2.field2 IN vitems
>
>SCAN FOR vitems.clordno = Order_List.cordno
...
>ENDSCAN
>
>
< snip >
I don't know what the problem is, but I've a couple of comments.
First, SEEK before SCAN FOR is useless because SCAN FOR ignores current record pointer position. In addition, 'SET ORDER TO TAG ordkey IN vitems' could significantly slow down SCAN FOR.
--sb--