I have had all kinds of problems with this. I have tried FLUSH with no luck either. My issue lies around the fact that I had a timer on the form that would update another users changes. Also, I would get tableupdate errors from replace commands in the code on the form updating fields that were not displayed.
The solution that I came to (actually derived from Rick Strahl's westwind code) was to do a skip -1, skip +1 to force the record to refresh before doing the replace or table update commands. The other solution was to put the fields I needed "off screen" and update the values then do a tableupdate.For some fields using replace command just gave me weird results and I have never fully understood why. HTH Alan On Thu, Oct 7, 2010 at 8:42 PM, Steve Ellenoff <[email protected]> wrote: > Hopefully the toilet yes, but I'm wondering how many people on the > list have a manual flush command to force updates in your fox apps? > > I have an application that is occasionally just having data > disappear. More accurately, the data seems to revert to a previous > state, ie, a user pulls up a record saves some changes, sees the new > changes in the form ( since the form re-loads the record after save), > and then sometime later ( nobody is sure the time frame could be days > or weeks later ), pulls up the same record and finds the new changes > are completely gone. > > Anyone have ideas? > > I was wondering if I need to add "flush"ing to my save code? > > [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.
