With current version 7.6 I setup an enter form with an ON Row Exit eep containing a Property Table <tablename> 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: <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> 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" <[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 >> >>
