Live action tracking

[nuke_girl]

Hi Everyone,

I was just asked by my supervisor about the possibility of live tracking of action within the Oracle database that we pull our data from. Our system involves employees logging in, at which time a new record is created in our access history data table with a blank field instead of a log out time. In other words, it's possible through a simple query to figure out who is in the system at any one time (I tried it out just to make sure!). What he wants to be able to see, however, is a "live" form that will list everyone in the system, and update everytime a new person logs in or out.

I figure that this is somehow possible, even if I just make the system refresh every few seconds. I just don't know how to build it, and I'm looking for confirmation that it is in fact possible, and maybe ideas on how to do it.

I'm thinking that a form using a Timer Event would be the way to go, but I'm not sure how to set it up. I don't know much code or how to use it, but I'm trying to learn, so if the solution is somewhat more complicated than just setting a property somewhere, I'd be willing to give it a go, but may need some hand-holding to get through it.

Does anyone have any suggestions??

Thanks,
~ N ~

 

[pbaldy]

I would think that you could build a form based on a query that displayed all records with no log out time (users still logged in). Then you could simply requery the form in the timer event, at whatever interval was appropriate.