Thank you to all for the suggestions. Razzak assures me that R:Base 7.0 will refresh the screen without going through all of the hassle. I just got a bite from the customer, so I will try that route.
Midge Nielsen JT3 (801)777-9653 -----Original Message----- From: Ben Petersen [mailto:[EMAIL PROTECTED] Sent: Thursday, 04 September, 2003 12:43 To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: Automatically updating a form You could compensate by adding a row for each user. "Sel OnOff into vStop from Flags whe UserID = yadayada" as well as the update. Of course it would require some thought, but it wouldn't be rocket science. Ben Petersen On 4 Sep 2003, at 11:15, Victor Timmons wrote: > Thats not a bad idea. The only problem maybe in a multi user. When the flag got > set to off all sessions would stop refreshing > > On 4 Sep 2003 at 10:49, Ben Petersen wrote: > > > I think as long as the eep is "pausing" rbase ignores user keyboard and > > mouse activity. > > > > I haven't thought this all the way through, but you might try this: > > > > 1) Create a table with one row and one column ie, Flags with column OnOff > > integer. > > > > 2) With the intention of using one form for viewing only and another for > input, > > copy your existing form and add a button "Stop Viewer". The attached eep > > would have a line "Update Flags set OnOff = 0" (that's zero) > > > > 3) Modify the command file that starts your viewing form: > > > > Update Flags set OnOff = 1 <--- > > > > LABEL START > > > > EDIT USING YourFormsName > > > > Sel OnOff into vStop from Flags whe limit = 1 <--- > > > > If vStop = 1 Then <--- > > GOTO Start > > Endif <--- > > > > > > 4) Open one rbase session to display the form that is in a loop for display. > > And, actually, I suppose this could just as well be a report that prints to > > screen. > > > > 5) Open a second session of rbase for data entry and for the purpose of > > stopping the viewer > > > > > > Ben Petersen > > > > > > On 4 Sep 2003, at 8:21, Nielsen Midge D Contr 388 RANS/JT3 wrote: > > > > > None of the buttons on the form work, including the exit button. The only > > > way to exit R:Base is to use the Task Manager to end the application. > > > > > > Midge Nielsen > > > JT3 > > > (801)777-9653 > > > > > > > > > -----Original Message----- > > > From: Victor Timmons [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, 03 September, 2003 17:55 > > > To: [EMAIL PROTECTED] > > > Subject: [RBASE-L] - Re: Automatically updating a form > > > > > > > > > If they are closing the form, then whats the problem. The form will refresh > when > > > they open it again??? > > > > > > On 3 Sep 2003 at 16:34, Nielsen Midge D Contr 388 RANS/JT3 wrote: > > > > > > > Victor, > > > > I really appreciate your suggestions. Thank you. The controllers mostly > view > > > > the screen, but occasionally they enter initials or a frequency. > > > There > > > > are times when they will need to get out of the system for maintenance or > > > > whatever. The pause for 60 works okay, but how do close the form when > the > > > > exit buton doesn't work because of the pause. > > > > > > > > Midge Nielsen > > > > JT3 > > > > (801)777-9653 > > > > > > > > > > > > -----Original Message----- > > > > From: Victor Timmons [mailto:[EMAIL PROTECTED] > > > > Sent: Wednesday, 03 September, 2003 15:50 > > > > To: [EMAIL PROTECTED] > > > > Subject: [RBASE-L] - Re: Automatically updating a form > > > > > > > > > > > > Is the person entering the data the same person that is viewing the data. > > > > Maybe you need an entry form and a viewing form. They could look the same > but > > > work > > > > > > > > differently. > > > > Maybe you could do something like this > > > > 1. Setup a simple command file > > > > > > > > LABEL START > > > > EDIT USING test2 > > > > SET VAR vWhatEver = 0 > > > > > > > > While vWhatEver < 480 then > > > > SET VAR vWhatEver = vWhatEver + 1 > > > > EDIT USING test2 > > > > ENDWHILE > > > > > > > > DIALOG 'It has been 8hrs would you like to start the refresh over again' > > > > vYesNo vEndKey NO IF vYesNo = 'NO' THEN > > > > GOTO Done > > > > ELSE > > > > GOTO Start > > > > ENDIF > > > > > > > > LABLE Done > > > > > > > > 2. Then in the form Menu - Layout - Table Settings - On row entry > > > > put a command file with something like this > > > > > > > > PAUSE FOR 60 > > > > CLOSEWINDOW > > > > RETURN > > > > > > > > This will loop for 8hrs and give the option to start it over when done. > > > This > > > > > > > > will lock the form but if all your doing is viewing the data. > > > > > > > > > > > > On 3 Sep 2003 at 11:14, Nielsen Midge D Contr 388 RANS/JT3 wrote: > > > > > > > > > Victor, > > > > > I played with the pause for n, and the help topic on pause claims that > > > any > > > > > keystroke will interupt the pause, but it doesn't. I got the command > > > > files > > > > > to update the screen, but it locks the form and I can't input anything > > > > into > > > > > the field, nor can I exit the form without using the Task Manager. > What > > > > am > > > > > I doing wrong? > > > > > > > > > > Midge Nielsen > > > > > JT3 > > > > > (801)777-9653 > > > > > > > > > > > > > > > -----Original Message----- > > > > > From: Victor Timmons [mailto:[EMAIL PROTECTED] > > > > > Sent: Tuesday, 02 September, 2003 17:47 > > > > > To: [EMAIL PROTECTED] > > > > > Subject: [RBASE-L] - Re: Automatically updating a form > > > > > > > > > > > > > > > You could put in a while loop. The problem with that is the loop runs > > > out. > > > > > In a > > > > > region i have used NEXTROW PREVROW to refresh a row. I would hope that > > > the > > > > > new > > > > > rbase refreshes data better. > > > > > > > > > > On 2 Sep 2003 at 17:02, Nielsen Midge D Contr 388 RANS/JT3 wrote: > > > > > > > > > > > Thank you for the suggestion. I am trying this, but in between other > > > > > things > > > > > > going on. Initially, it got stuck in a loop. I will keep playing > > > with > > > > > it. > > > > > > > > > > > > Midge Nielsen > > > > > > JT3 > > > > > > (801)777-9653 > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > From: Victor Timmons [mailto:[EMAIL PROTECTED] > > > > > > Sent: Tuesday, 02 September, 2003 15:04 > > > > > > To: [EMAIL PROTECTED] > > > > > > Subject: [RBASE-L] - Re: Automatically updating a form > > > > > > > > > > > > > > > > > > You could do this > > > > > > > > > > > > 1. Setup a simple command file something like this > > > > > > > > > > > > LABEL START > > > > > > EDIT USING YourFormsName > > > > > > GOTO Start > > > > > > > > > > > > 2. Then in the form Menu - Layout - Table Settings - On row entry put > > > > > > a command file with something like this > > > > > > > > > > > > PAUSE FOR 60 > > > > > > CLOSEWINDOW > > > > > > RETURN > > > > > > > > > > > > This will close and reload the form every 60sec > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > On 2 Sep 2003 at 14:36, Nielsen Midge D Contr 388 RANS/JT3 wrote: > > > > > > > > > > > > > I have been searching to no avail for a way to automatically update > > > a > > > > > form > > > > > > > while the form is open. I have a group of users that are > constantly > > > > > > > updating information in a scheduling table (schedulers). I also > > > have > > > > > > other > > > > > > > users (Air Traffic Controlers) that have a form open that contains > > > the > > > > > > data > > > > > > > that the schedulers are updating. I need a way to update the (Air > > > > > Traffic > > > > > > > Controller) form without the controllers having to press any > > > buttons. > > > > > > > Currently, I have an update button that must be pressed, that > closes > > > > the > > > > > > > form and reopens the same form with current data. Does anyone have > > > a > > > > > way > > > > > > to > > > > > > > update the form without pressing any buttons (other than Web- > based)? > > > > > > > > > > > > > > Midge Nielsen > > > > > > > JT3 > > > > > > > (801)777-9653 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Victor Timmons > > > > > > Tiz's Door Sales, Inc > > > > > > 425-258-2391 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Victor Timmons > > > > > Tiz's Door Sales, Inc > > > > > 425-258-2391 > > > > > > > > > > > > > > > > > > > > > > > > > > Victor Timmons > > > > Tiz's Door Sales, Inc > > > > 425-258-2391 > > > > > > > > > > > > > > > > > > > > Victor Timmons > > > Tiz's Door Sales, Inc > > > 425-258-2391 > > > > > > > > > > > Victor Timmons > Tiz's Door Sales, Inc > 425-258-2391 >
