Dawn, I must have read your mind from a distance! As I sent my last email with the dummy table solution, your email came in with the same solution.
I wonder if this should be submitted as a enhancement to variable forms? Thanks again. Bob -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: [EMAIL PROTECTED] 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 >
