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: Craig Moore
  Where is Craig Moore?
 
 United Kingdom
 Craig Moore
 Tags
Subject: RE: tableupdate()
Thread ID: 22082 Message ID: 22089 # Views: 23 # Ratings: 0
Version: Visual FoxPro 7 Category: General VFP Topics
Date: Tuesday, April 08, 2003 6:48:16 PM         
   


> Mike, i think they should be able to use table buffering as only update the current record with tableupdate, i am just nost sure if this undoes any other changes or if they need the tablerevert. However using row buffering would eliminate the problem but you must trap the cursor move to prompt for save or undo, as moving the record cursor will update changes on a row buffered table.
>
> I think this is clear as mud?
>
> >
> > 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

That's exactly what I was thinking. I got to looking at the TABLEUPDATE() command and if you use the .F. switch for the rows, even with table buffering on it only commits the change to the current record. I didn't realize that. That's why I suggested using row buffering. But like you said, then you've got the problem of trapping the record pointer movement. It's just something that Troy will have to test and see what's best for him.

---

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