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
> 

Reply via email to