On Fri, Oct 3, 2008 at 10:23 AM, MB Software Solutions General Account <[EMAIL PROTECTED]> wrote: > Rick Schummer wrote: >>>> 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.<< >> >> Please note the lower the number the higher the network traffic you will > introduce. Set wisely. >> >> Rick >> White Light Computing, Inc. > > > Good point. That's why I prefer a separate data set locally (e.g., > views/cursors) and then only requery on demand. That data access > strategy has never failed me, and once I changed over to that design, I > got past many data "anomalies" with just using buffered vfp table data. --------------------------------------------------
Not just to Michael. In reality, what are you getting in a refresh? 1) any updates done while this data was brought local. 2) secondary data refresh for inventory count >0 3) some other reason? >From that reply you have to design how you want to handle the situation. for #1 attempt your update as dynamic SQL to only update row(s) because the same starting data exists for the overwrite against the dataset you currently have. So you build up the list of columns to apply your change(s) to and then run it. If you get a count back >0 for rows changed great. Otherwise someone beat you to an edit. For a #2 you have to just query that your count of existing ??? is still available before you write the row. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 _______________________________________________ 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.
