Excellent! Seems the case is resolved! Thanks, Bob
-- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: "MikeB" <[EMAIL PROTECTED]> > With current version 7.6 > > I setup an enter form with an ON Row Exit eep containing a Property Table > Refresh 'TRUE' > > with your code structure in the timer form (which is a variable form started > Edit using FormName MDI as ALIASName) > > and it updates the variable field on the form properly > > > > > > > ----- Original Message ----- > From: > To: "RBASE-L Mailing List" > Sent: Thursday, January 24, 2008 9:49 AM > Subject: [RBASE-L] - Re: Timer question - Workable resolution > > > > 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" > > > >> > >> > >> 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 > >> > >> > >
