Dawn, Sorry I missed the dummy table part. Yes anything to force a flush to disk would do it.
----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, January 24, 2008 9:35 AM Subject: [RBASE-L] - Re: Timer question > For his purposes, I would rather see the unbound form so there are no issues > with locking, ever. > > His architecture should work, we just need to be certain the new record added > is flushed to disk so the Select is acting on the entire recordset. > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Thursday, January 24, 2008 9:25 AM > Subject: [RBASE-L] - Re: Timer question > > >> Bob, >> I've found that if rather than a variable form, you associate the form >> with a dummy table, then use the PROPERTY TABLE dummy 'refresh', it works >> just fine. >> >> Dawn Hast >> Dairpak Business Systems Group >> Blue Ridge Paper Products, Inc. >> >> >> >> [EMAIL PROTECTED] wrote on 01/24/2008 08:53:18 AM: >> >>> I am now really confused. (Which is not unusual for me sometimes!) >>> >>> I started a fresh this morning on my timer project. To recap, I >>> have a timer with the intention >>> of automatically updating a display on a form. For now, we are >>> keeping it simple and simply >>> finding the maximum number in a table. The timer fires as expected, >>> but when another user >>> increases the value in the table, the timer's Select statement does >>> not find it until I exit the >>> form and go back in. Form is a variable form with no tables. >>> Select statement is a simple >>> Select (Max(column)) into ..... >>> >>> >>> So I added one line of code to the timer EEP to make it as follows: >>> >>> --Test EEP >>> Browse MONumber from M1Table >>> Select (Max(MONumber)) into vMaxMo from M1Table >>> >>> Recalc variables >>> return >>> -- >>> >>> The EEP will find the correct max MONumber if I place the browse >>> command in the EEP. If I remove >>> the Browse command, the variable vMaxMo never gets updated until I >>> close the form and re-enter. >>> >>> So it seems that the Browse command causes a buffer to flush and >>> will obtain the latest table entries, while the Select command does >>> not. If I cut and paste the Select command from the eep to the R:>, >>> it will pick up the latest max value. But within the Timer EEP it does >> not. >>> >>> The question then is how can I force the buffer refresh/flush in the >>> timer EEP? My whole project depends upon being able to have a form >>> that is automatically updating several values on screen as it will >>> be a "Master Control" panel for manufacturing system. The form >>> timer should be the perfect tool for this and is how I want to >>> proceed if possible. >>> >>> Thanks, >>> -Bob >>> >>> -- >>> Thompson Technology Consultants >>> LaPorte, IN 46350 >>> 219-363-7441 >>> > > >
