>>>I have a form with a one table in the dataenvironment with the BufferModeOverride set to 2 (pessimestic row buffering) - and SET MULTILOCKS is ON. Here is the problem I have. When the user clicks on the 'Edit' button (enables the fields for editing), makes a change and clicks on 'Cancel' (which has TABLEREVERT()) - the changes are saved rather reverting back to the original values.
>>>
>>>What am I missing?
>>>
>>>Thanks, AL
>>
>>Al,
>>
>>Do you move the record pointer in the table at any time during the edit? If so, FoxPro will automatically save the changes. If you need to move the record pointer during the edit, you'll need to use table buffering.
>
>I had a problem exactly like this and the problem was what Josh has described. Allan, trace your code and determine if at any point during editing you move the record pointer before issuing TABLEREVERT().

Sometimes it is easy to forget the obvious. It helps to do a thisform.refresh() after tablerevert(). That's all I was missing - the table wasn't being updated - the screen just wasn't being refreshed after the tablerevert.

AL