Mike, I had even made data changes from the second session at the R:> using an edit all from ... statement and still no changes with the variable based form. This project is still in 7.5 (I know, I know...) so I hestiate to submit it until I get a chance to test it in 7.6.
Thanks, -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: "MikeB" <[EMAIL PROTECTED]> > > > Refresh on the Form from which the data was entered. > > ----- Original Message ----- > From: > To: "RBASE-L Mailing List" > Sent: Thursday, January 24, 2008 9:34 AM > Subject: [RBASE-L] - Re: Timer question - Workable resolution > > > > Rachael, > > I had tried the Refresh option, however the form was a variable form (no > > table) and the REFRESH did not have any effect. > > I had made this form a variable form, as the intention was to be displaying > > updated information from > > several tables and not for entering/editing data from any of them. Just > > displaying status information. > > > > So after more experimenting, I found a workable solution. I based the form > > on a dummy table instead of > > making it a Variable Form. The Dummy table has only one record in it and > > has > > nothing to do with the lookup > > functions in the Timer EEP. I then placed a Property Table DummyTab > > 'Refresh' line at the start of the Timer > > EEP and lo and behold.... all variables were refreshed properly. > > > > I am now on my way ! > > > > -Bob > > > > -- > > Thompson Technology Consultants > > LaPorte, IN 46350 > > 219-363-7441 > > > > -------------- Original message -------------- > > From: "Rachael Malberg" > > > > 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 > >
