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 >>
