Refresh on the Form from which the data was entered.
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> 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" <[EMAIL PROTECTED]> > > 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
