> > 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!

The only thing I can think of is to set your buffer mode to 2 or 3 (row buffering). Then, before the record pointer moves and automatically commits changes, do a TABLEREVERT() on records you don't want to keep.

---

www.foxite.com - The Home of the Visual FoxPro Experts