>>>That is not how you use GetNextModified.
>>>local lnRecNo
>>>lnRecNo = 0
>>>lnRecNo = GetNextModified(lnRecNo, "MyTableAlias")
>>>do while lnRecNo <> 0
>>>
>>> lnRecNo = GetNextModified(lnRecNo, "MyTableAlias")
>>>enddo
>>
>>Hi Mark,
>>I believe what he coded will work if he does a TableUpdate(1) or TableRevert(.F.) on each hit.
>
>Yes, if that was what he was doing. Somehow, I don't think that was the case. I was real confused because at one point he said he was using SPT [first reply to Hiten Kishor].
As I understood it, he used SPT to get the data.
Made an updatable cursor with Table buffering.
Made changes.
Issued TableUpdate(2)
Then was trying to handle the failed updates.
I'd suggested looping and issuing the singleton TableUpdate(1) or TableRevert(.F.) on each hit as needed.
Otherwise, endless loop!
Bill Armbrecht
VFP MCP