I am using the tableupdate command, although I am not checking the results but the data is getting saved to the table, because I can confirm with another instance of VFP9 and the data is updated ok.
The data will update in the old app ok, if I exit out of the new app. I even added code to close the table after the update to make sure the data is written to disk. -----Original Message----- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, January 18, 2012 6:26 PM To: profox@leafe.com Subject: RE: Data not updating As Fred mentioned, are you either moving the record pointer after an edit or calling TABLEUPDATE()? You may also want to try FLUSHing the workarea in question. Windows may be "helpfully" caching writes for you and the FLUSH command theoretically addresses that. -- rk -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kent Belan Sent: Wednesday, January 18, 2012 6:19 PM To: profoxt...@leafe.com Subject: RE: Data not updating Both old and new apps are have buffering set to 3 on all tables. I have coded the new app to close the table just after the save and just prior to the load. I thought this would clear the buffers and write the data to disk but the old app still pulls the old data -----Original Message----- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Fred Taylor Sent: Wednesday, January 18, 2012 6:16 PM To: ProFox Email List Subject: Re: Data not updating If the new app is data buffering, the data is NOT written to the file until the record pointer is moved. If you're still on the same new record, it's "not real" yet. Fred On Wed, Jan 18, 2012 at 3:59 PM, Kent Belan <kbe...@mchsi.com> wrote: > Richard just asked about SET REFRESH and SET REPROCESS > > Set Refresh to 2 in old app but not used in new app. > > I can check immediately or 5 minutes later and the old app is still > showing the old data. > > The old app only shows the new data if I exit out of the new app > > > > -----Original Message----- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On > Behalf Of MB Software Solutions,LLC > Sent: Wednesday, January 18, 2012 5:49 PM > To: ProFox Email List > Subject: Re: Data not updating > > On 1/18/2012 5:35 PM, Kent Belan wrote: > > Yes, we are using the tables directly, thru a business object layer. > > > > And yes, we are using table buffering 3 - Optimistic Row Buffering > > > You might check out the SET REFRESH setting in VFP help. I know Rick > has mentioned that here before. > > How long after are you checking and not noticing the difference? > Immediately, 5 seconds later, or what? > > > -- > Mike Babcock, MCP > MB Software Solutions, LLC > President, Chief Software Architect > http://mbsoftwaresolutions.com > http://fabmate.com > http://twitter.com/mbabcock16 > [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/F1E3FE814C76443695DC710A9D4775C2@LaptopW7 ** 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.
