Rick Schummer wrote: >>> If I make a change in one form, how can I get the other form to recognize >>> the updated data ?<< > > It depends on what you mean by getting the other form to recognize the data > changes. Do you need the > other form(s) to reflect the changes to the current record in the updated > form directly (like the > form is a dashboard and is displaying the latest changes)? Or are you saying > the user might switch > to the form and navigate to the record and should see the recent changes? > > Depends on whether you are using direct VFP table access, local views of VFP > tables, or remote data. > For VFP tables you need to check out the SET REFRESH command. For local or > remote views you need to > Requery() the views, and probably tweak the SET REFRESH command. Note: the > second parameter of the > SET REFRESH command is the one to tweak. Getting this setting optimized will > depend on the users > need for fresh data vs. how much network traffic they can tolerate. > > If it is the dashboard scenario you need to consider the concept of a Form > Manager object to message > the other forms that need to perform some code to get the refresh to happen. > Kind of what John was > referring to in his framework answer.
Both great replies. Let us know what your situation is and perhaps the tailored answer can help someone else too! _______________________________________________ Post Messages to: [email protected] 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.
