Hello John and Rick, Thanks for the help, I will check out the SET REFRESH command and see if that helps.
I don't use a framework, but am familiar with application objects. The program is fairly basic, mostly modal forms and free tables, but I recently changed two forms to be modeless with private data sessions, so both forms can be active at the same time. Both forms share several tables and if I add a record to a shared table in one form it does not display in the other form unless I exit the form and reload the form. I just tested it again and this time it did not display in the second form until I quit out and started the app again. I checked the table and the record is there. I just tried the same test with SET REFRESH TO 1 and it did not change anything. What is the trick to get the other form to recognize the new record added ? Thanks, Kent > > >>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. > > Rick > White Light Computing, Inc. > > www.whitelightcomputing.com > www.swfox.net > www.rickschummer.com > > > > [excessive quoting removed by server] _______________________________________________ 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.
