Re: RE: Data not updating -> [OT]

2012-01-25 Thread AndyD
thanks, yes, very well. Been retired 5 years now (where does time go?) - so decided to stir up the little grey cells by having a 3rd (and final) attempt at Python** so I've been following profox to help get my programming head on again. cheers - AndyD 8-)₹ P.S. ** tried a book called "Programmi

RE: Data not updating

2012-01-23 Thread Jerry Wolper
> Andy Kramek gave a talk on this at one of the Prague DevCons... > > Andy Davies Good to hear from you. I hope all's well. -Jerry ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free versio

RE: Data not updating

2012-01-21 Thread AndyHC
Hi all, Andy Kramek gave a talk on this at one of the Prague DevCons - there is some stuff by him at http://weblogs.foxite.com/andykramek/2005/10/18/buffering-and-locking-in-visual-foxpro-an-overview/ but the DevCon presentation was better if anyone has access to it. Andy Davies P.S. see the

RE: Data not updating

2012-01-20 Thread Kent Belan
not updating in the old app until I exit the new app. This problem SUCKS !!! -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Thursday, January 19, 2012 11:32 AM To: profox@leafe.com Subject: Re: Data not updating

Re: Data not updating

2012-01-19 Thread Christof Wollenhaupt
Kent, Your old app is using SEEK to locate the record? That should move the record pointer and update the record buffer. Could you add a BROWSE right after the SEEK command to ensure that it's not something else in the app that shows old data but truly the table. How did you verify that both app

Re: Data not updating

2012-01-19 Thread Frank Cazabon
in the old app. > > > > -Original Message- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf > Of Alan Bourke > Sent: Thursday, January 19, 2012 11:01 AM > To: profox@leafe.com > Subject: RE: Data not updating > > > > On Thu,

Re: Data not updating

2012-01-19 Thread Stephen Russell
On Thu, Jan 19, 2012 at 10:14 AM, Kent Belan wrote: > Hello Alan, > > Yes, both old and new apps are accessing the same dbf tables. > > When I exit the new app, all the data magically appears in the old app. --- WAG here. Old app pulls data local New app does the same. Edits

RE: Data not updating

2012-01-19 Thread Kent Belan
, 2012 11:01 AM To: profox@leafe.com Subject: RE: Data not updating On Thu, Jan 19, 2012, at 09:31 AM, Kent Belan wrote: > > I made changes to close and reopen the ticket table in the old app > just prior to loading the ticket but it still shows the old data. Is it pointing at the

RE: Data not updating

2012-01-19 Thread Alan Bourke
On Thu, Jan 19, 2012, at 09:31 AM, Kent Belan wrote: > > I made changes to close and reopen the ticket table in the old app just > prior to loading the ticket but it still shows the old data. Is it pointing at the same data ? -- Alan Bourke alanpbourke (at) fastmail (dot) fm

RE: Data not updating

2012-01-19 Thread Kent Belan
: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Christof Wollenhaupt Sent: Thursday, January 19, 2012 6:01 AM To: profox@leafe.com Subject: Re: Data not updating Does the old app move the record pointer or attempts to lock the record when it refreshes data? Otherwise you

RE: Data not updating

2012-01-19 Thread Paul Newton
Subject: RE: Data not updating I have the code to the old app and can make changes. I have put code in to close and reopen the table just prior to loading the record in the old app, but that does not get the new data. -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun

RE: Data not updating

2012-01-19 Thread Kent Belan
Software Solutions,LLC Sent: Wednesday, January 18, 2012 6:58 PM To: ProFox Email List Subject: Re: Data not updating On 1/18/2012 6:34 PM, Kent Belan wrote: > Never had problems with buffering set to 3 before, but this is the > first time running to separate VFP9 apps against the same data

RE: Data not updating

2012-01-19 Thread Kent Belan
Jarvis, Matthew Sent: Wednesday, January 18, 2012 6:31 PM To: profox@leafe.com Subject: RE: Data not updating > Ok, good test. I opened both the old app and new app and an extra VFP9. > > Old app showed date 1/18/2012. > > Changed date in new app to 1/19/2012. > > Reloaded

Re: Data not updating

2012-01-19 Thread Christof Wollenhaupt
Does the old app move the record pointer or attempts to lock the record when it refreshes data? Otherwise you will never see the changes being reflected no matter what SET REFRESH is set to. If you can't change the code extend your test to navigate to a different record in the old app and then back

Re: Data not updating

2012-01-18 Thread MB Software Solutions, LLC
On 1/18/2012 6:34 PM, Kent Belan wrote: > 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 un

Re: RE: RE: Data not updating

2012-01-18 Thread Frank Cazabon
Check if disk write caching is on. If it is switch it off On 18 Jan 2012 19:38, "Frank Cazabon" wrote: Was wondering if smb2 was coming into play. Maybe there's some kind of caching being done by windows? > > On 18 Jan 2012 19:30, "Kent Belan" wrote: > > Right now I am testing both ap... > >

Re: RE: RE: Data not updating

2012-01-18 Thread Frank Cazabon
Was wondering if smb2 was coming into play. Maybe there's some kind of caching being done by windows? On 18 Jan 2012 19:30, "Kent Belan" wrote: Right now I am testing both apps on the same computer running in the same folder. -Original Message- From: profox-boun...@leafe.com [mailto:p

RE: Data not updating

2012-01-18 Thread Kent Belan
. -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@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 buffer

RE: Data not updating

2012-01-18 Thread Kent Belan
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

RE: Data not updating

2012-01-18 Thread Jarvis, Matthew
> Ok, good test. I opened both the old app and new app and an extra VFP9. > > Old app showed date 1/18/2012. > > Changed date in new app to 1/19/2012. > > Reloaded record in old app and still showed 1/18/2012 > Just out of curiosity, what about other field types such as integer or text? Tha

RE: RE: Data not updating

2012-01-18 Thread Kent Belan
Right now I am testing both apps on the same computer running in the same folder. -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Frank Cazabon Sent: Wednesday, January 18, 2012 6:25 PM To: profox@leafe.com Subject: Re: RE: Data not

Re: Data not updating

2012-01-18 Thread MB Software Solutions, LLC
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

RE: Data not updating

2012-01-18 Thread Richard Kaye
al 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 ap

Re: RE: Data not updating

2012-01-18 Thread Frank Cazabon
Is a network involved, or is this happening with both apps and data on the same computer? On 18 Jan 2012 19:19, "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 tho

RE: Data not updating

2012-01-18 Thread Kent Belan
: profox@leafe.com Subject: RE: Data not updating > > The old app only shows the new data if I exit out of the new app > Okay, so does the old app see a table change if it is done manually through a browse window? Thanks, Matthew Jarvis || Business Systems Analyst IT Department

Re: Data not updating

2012-01-18 Thread MB Software Solutions, LLC
On 1/18/2012 5:59 PM, Kent Belan wrote: > The old app only shows the new data if I exit out of the new app Now it's clear why the old app needed to be replaced. lol -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmat

RE: Data not updating

2012-01-18 Thread Kent Belan
- 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&#x

Re: Data not updating

2012-01-18 Thread Fred Taylor
--- > 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 usi

RE: Data not updating

2012-01-18 Thread Jarvis, Matthew
> > The old app only shows the new data if I exit out of the new app > Okay, so does the old app see a table change if it is done manually through a browse window? Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield,

RE: Data not updating

2012-01-18 Thread Kent Belan
- 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 busin

RE: Data not updating

2012-01-18 Thread Kent Belan
@leafe.com Subject: RE: Data not updating What values do you have for SET REPROCESS and SET REFRESH ? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kent Belan Sent: Wednesday, January 18, 2012 5:41 PM To: profoxt...@leafe.com

Re: Data not updating

2012-01-18 Thread MB Software Solutions, LLC
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 af

RE: Data not updating

2012-01-18 Thread Richard Kaye
What values do you have for SET REPROCESS and SET REFRESH ? -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kent Belan Sent: Wednesday, January 18, 2012 5:41 PM To: profoxt...@leafe.com Subject: RE: Data not updating No

RE: Data not updating

2012-01-18 Thread Kent Belan
-boun...@leafe.com] On Behalf Of Jarvis, Matthew Sent: Wednesday, January 18, 2012 5:08 PM To: profox@leafe.com Subject: RE: Data not updating > > What would cause the old app to not read the most current data from the > shared table ? > > I even closed the table and reopen just

RE: Data not updating

2012-01-18 Thread Kent Belan
18, 2012 5:22 PM To: ProFox Email List Subject: Re: Data not updating On 1/18/2012 4:58 PM, Kent Belan wrote: > Hello, > > Ok, this is a weird one. > > I am building a new VFP9 app to replace an old outdated VFP9 app (long > story). > > Both apps use the same DBF free t

Re: Data not updating

2012-01-18 Thread MB Software Solutions, LLC
On 1/18/2012 4:58 PM, Kent Belan wrote: > Hello, > > Ok, this is a weird one. > > I am building a new VFP9 app to replace an old outdated VFP9 app (long > story). > > Both apps use the same DBF free tables. > > If I update a field in the new app, the old app does not reflect the change > until I ex

RE: Data not updating

2012-01-18 Thread John Weller
h-boun...@leafe.com] On Behalf > Of Jarvis, Matthew > Sent: 18 January 2012 22:08 > To: profoxt...@leafe.com > Subject: RE: Data not updating > > > > > What would cause the old app to not read the most current data from > the > > shared table ? > > > > I eve

RE: Data not updating

2012-01-18 Thread Jarvis, Matthew
> > What would cause the old app to not read the most current data from the > shared table ? > > I even closed the table and reopen just before the seek and it still loads > the old data > > Very weird ... Help > > Thanks, > Kent Does any of this involve cursors? If so are they really s

RE: Data not updating

2012-01-18 Thread Jarvis, Matthew
> What would cause the old app to not read the most current data from the > shared table ? > "I am building a new VFP9 app to replace an old outdated VFP9 app (long Story)" Maybe THAT's your reason. Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamet