> if your tableupdate works, then i think tablerevert should do the trick
>
> > > Hello,
> > >
> > > I am using table buffering on a form. I only want changes made to the current record committed with tableupdate(). What's the coding? I have tried;
> > >
> > > SET MULTILOCKS ON
> > > CURSORSETPROP('Buffering',5,'phones')
> > >
> > > In the command button for Committ changes:
> > >
> > > TABLEUPDATE(.T.) and have tried TABLEUPDATE(.F.)
> > >
> > > What am I missing?
> > >
> > > Troy
> > > Long Live FoxPro!
> >
> > Ok, I have figured out that the TABLEUPDATE(.F.) is working. However, here is what I am trying to do. After the TABLEUPDATE(.F.) has been issued, I would like any other changes made to the table for any other records except the current record to be reset back to the original values. This way it does not appear to the user that changes made to other records have been updated. Any suggestions?
> >
> > Troy
> > Long Live FoxPro!

I got it! Thanks for the suggestions. It helped. Here is what I found;
updating the current record only,,, only seems to work if CURSORSETPROP() is set at 4 or 5 and TABLEUPDATE(.F.). Also, to reset any changes made to all other records except the current record I issued a TABLEREVERT(.T.) rightafter the TABLEUPDATE(.F.) in my committ changes button and that worked. It updates changes in current record then resets any changes to all other records back to OLDVAL(). Of course, it keeps the change made to the current record.

Yeah! Success at last.

Troy
Long Live FoxPro!