Author: Kent Belan
Posted: 2012-01-18 at 18:34:17
Never had problems with buffering set to 3 before, but this is the first
time running to separate VFP9 apps against the same data tables.
I am doing a tableupdate after the replace commands, but the new data still
is not displaying in the old app unless I exit out of the new app.
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf
Of MB Software Solutions,LLC
Sent: Wednesday, January 18, 2012 6:27 PM
To: ProFox Email List
Subject: Re: Data not updating
On 1/18/2012 6:19 PM, Kent Belan wrote:
> 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
I saw long ago advice that said to always use TABLE buffering (5) instead of
ROW buffering (3). Just a tip. Reasons were that row buffering sometimes
left you with intended consequences (like commits on row changes) and
perhaps something about performance too. (Makes sense, if you think about
it.)
Is the data being committed with a TABLEUPDATE explicitly?
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
[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/13996F9F55224AF0835E0AE38E53612E@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.