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
