Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Michael Gill
  Where is Michael Gill?
 Flora
 Illinois - United States
 Michael Gill
 To: Troy Reganall
  Where is Troy Reganall?
 Toledo (OH)
 Ohio - United States
 Troy Reganall
 Tags
Subject: RE: tableupdate()
Thread ID: 22082 Message ID: 22084 # Views: 29 # Ratings: 0
Version: Visual FoxPro 7 Category: General VFP Topics
Date: Tuesday, April 08, 2003 4:37:55 PM         
   


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

COMPLETE THREAD

tableupdate() Posted by Troy Reganall @ 4/8/2003 4:07:52 PM
RE: tableupdate() Posted by Troy Reganall @ 4/8/2003 4:24:09 PM
RE: tableupdate() Posted by Michael Gill @ 4/8/2003 4:37:55 PM
RE: tableupdate() Posted by Craig Moore @ 4/8/2003 5:43:21 PM
RE: tableupdate() Posted by Michael Gill @ 4/8/2003 6:48:16 PM
RE: tableupdate() Posted by Craig Moore @ 4/8/2003 4:54:54 PM
RE: tableupdate() Posted by Troy Reganall @ 4/8/2003 9:50:17 PM