Rick, Thanks Rick, it was the SET REFRESH setting I was missing. As soon as I changed it to 5,5 from 0,0 the form data refreshed.
Jim James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rick Schummer Sent: Thursday, October 02, 2008 8:05 PM To: profox@leafe.com Subject: RE: updating data on multi-user form Hi James, Table or view? If view is the table in the DE and buffered as well on either form in question? What is the second parameter for SET REFRESH set to? Timer does a refresh of the data how? You can try to RLOCK() and UNLOCK to trigger a refresh. Are you calling thisform.Refresh() thinking it could refresh the data? Refresh method only updates the form with the data in the buffer, not updating the buffer. If view, you need to perform a Requery(). Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Harvey Sent: Thursday, October 02, 2008 03:29 PM To: [EMAIL PROTECTED] Subject: updating data on multi-user form Having trouble getting the data on a form to update after a user on the same form on another pc on the network makes a edit to the data. Buffering is set to 5, and I'm using tableupdate to commit the change - tableupdate(1,.f.,'accounts'). There is a timer on the form that refreshes the form every 15 seconds, thereby updating the form and showing the changed data, but it is not working here. Is there another way to do this? James E Harvey Hanover Shoe Farms, Inc. M.I.S./Corresponding Officer Off: 717-637-8931 fax: 717-637-6766 email: [EMAIL PROTECTED] [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 Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** 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.
