Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Troy Reganall
  Where is Troy Reganall?
 Toledo (OH)
 Ohio - United States
 Troy Reganall
 To: Craig Moore
  Where is Craig Moore?
 
 United Kingdom
 Craig Moore
 Tags
Subject: RE: tableupdate()
Thread ID: 22082 Message ID: 22092 # Views: 0 # Ratings: 0
Version: Visual FoxPro 7 Category: General VFP Topics
Date: Tuesday, April 08, 2003 9:50:17 PM         
   


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

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