Good question.. The insert is done from a form unrelated to the timer form. So after the insert (by whatever method the record is added) in the bound data form, is the table refreshed?
And further, you do know the eep is firing because of the color change, but have you displayed the value of the variable in a PAUSE so you can see what the value returned is? ----- Original Message ----- From: "Rachael Malberg" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, January 24, 2008 9:02 AM Subject: [RBASE-L] - Re: Timer question Have you tried adding property table M1Table 'refresh' before your... Select (Max(MONumber)) into vMaxMo from M1Table Have a Fabulous Day! Rachael M. Freelance Developer www.DragonflyDevelopmentMN.com ----- Original Message ----- From: [EMAIL PROTECTED] To: RBASE-L Mailing List Sent: Thursday, January 24, 2008 7:53 AM Subject: [RBASE-L] - Timer question 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
