Re: How to get a form to continually update it's display.

Hi Craig,

How about :

• Defining a global variable or a package variable equating to, say, sysdate. Say, the user can stay connected for only X mins and start_time is the global/package variable.
• Start a timer in the ON-LOGON trigger of every form, with the timer value equal to the time the user can stay connected. If ( timer = sysdate - start_time) > 0 then thats the time the timer should count down. If value < 0 then prevent the log in. A when-timer-expired trigger, in every form, should force a log out. Note that the timer value in every form will be dynamic, with respect to the value in the global/package variable.
• This should take care of call_forms/open_forms with or without new_session option.

Sounds okay to me - haven't tried this out though.

Keep me/newsgroup posted on how you go on this.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : avion_at_ozemail.com.au / ssubrama_at_nibucorp.ccdn.otc.com.au

Disclaimer : All opinions are truly and just mine.

Craig Harper <caharper_at_hooked.net> wrote:


>Goal:

>

>We are trying to get a forms 4.5 app. to execute a query every 10 sec and 

>update it's screen.

>

>Problem:

>

>The problem is that when we use a trigger to perform this function if the 

>focus leaves the form (as often happens in multi-form apps) that has the 

>trigger associated with it the timer stops, pausing the 

>when_timer_expired que. We have created the time at the form level. 

>

>Question: (call for HELP)

>

>Is there any way to create the timer at the (application level)? So that 

>no matter where the focus is the timer continues to function?

>

>We also need to keep track of how long the user has been connected to the 

>DB and after a preset time limit disconnect them.

>

>Any sugguestions, tips. pointers, or comments are very welcome.

>

>Craig Harper

>IFTN 

>