Re: Forms Inactivity time-out?

[Quoted] "Michael J. Moore" <hicamel_at_home.com> wrote in message news:4M4i5.73854$i5.1168018_at_news1.frmt1.sfba.home.com...
> How is this kind of problem typically solved using Forms 6i?
> Joe pulls up the CUSTOMER record and start's to apply a change. This puts a
> lock on the record. Mary pulls up the same customer record but cannot change
> it because Joe has got it. Joe decides that this would be a great time to go
> on a 2 week vacation. He does not log off, does not commit, he just walks
> away in the middle of a transaction.
>
> How can Forms clean up Joe's mess ( release his lock and kill his session)
> after say 10 minutes of inactivity?
> Thanks.

[Quoted] Don't know about killing his session, but maybe try (just off the top of my [Quoted] head - not sure if this will work or now) a WHEN-TIMER-EXPIRED trigger? If you [Quoted] put it in your library and have all forms call it, start a timer on WHEN-NEW-FORM-INSTANCE. After a certain amount of time (a reasonable amount of [Quoted] time for someone to use a form - depends on your business), call an alert that [Quoted] asks if the user wants to commit or rollback. Start a new timer when you call [Quoted] this alert. If they don't respond within a minute or so, assume they're gone, [Quoted] and do a rollback and then maybe an EXIT_FORM(NO_VALIDATE).

Just a guess - not sure if it'll work or not but give it a shot and see what happens?

-Matt Received on Wed Aug 02 2000 - 00:00:00 CEST