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
