Assuming you are using tables and not views, you can use the SET REFRESH command to control how often VFP refreshes the local cache. The only other way to force VFP to refresh the local cache is to lock a record (which is what happens when you perform the TABLEUPDATE() in a optimistic buffering scenario).
If you are using local views then the data is only refreshed as often as a REQUERY() is performed on the view. Rick White Light Computing, Inc. www.whitelightcomputing.com www.rickschummer.com 586.254.2530 - office 586.254.2539 - fax -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kent Belan Sent: Monday, July 31, 2006 10:37 AM To: [EMAIL PROTECTED] Subject: RE: Buffering and TableUpdate() Hello Dave, Thanks for the reply. How do I refresh the data on computer 2 after computer 1 makes a change? I understand the timer, but do I have to seek the invoice or can I just do a thisform.refresh() Thanks, Kent > > Kent, > Unless you do a refresh of the data, the machine sitting on the > original record will not see the changes unless it tries to commit a > change of its own. Then and only then will you get an exception thrown > and you can decide what data is the "most up to date". You need to > refresh the data periodically in the original record form to see any > updates. > > If you are using grids or browse windows (uugh!) then these will > refresh automatically after the updates from the "new" form have been > committed if you set the "set refresh to " command accordingly. > > Note that this command setting only refreshes the "buffers" and may or > may NOT affect the displayed data (i.e it works with unbuffered grids > and memo fields). > > I usually use a timer to refresh the data on a form every 5 or 10 seconds. > > Dave Crozier > The secret to staying young is to live honestly, eat slowly, and to > lie about your age > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Kent Belan > Sent: 31 July 2006 15:11 > To: ProFox Email List > Subject: Buffering and TableUpdate() > > Hello, > I am having a problem with my application VFP9 SP1. > I have all free tables with optimistic row buffering. > > If I make a change on one computer and tableupdate() returns true, > other computers will not see the change to the data. > > Example, 2 computers are sitting on the same invoice. > Computer 1 makes a change to the invoice status, then computer 2 > attempts an operation that depends on the status but does not see the > changes. > > How do I get computer 2 to see the current values in the record? > > Thanks, > Kent > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.