Who else in the system

[FoxWing]

Just curious is there a way "in foxpro" to know who else login my database application beside myself ? I'm using Vfp 8 with foxpro database.

All i can think of now is usinf a free table, u_trace(usr_id,loginCnt). Everytime user login, update it based of the userid and +1 for login_cnt.

If user logout, update the login_cnt to -1.


eg:

usr_id, loginCnt
MIKE 1
JAMES 2


Will this approach work ?

 

[Mike Gagnon]

That is the way I would handle it.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[DSummZZZ]

To manually track users, yours is one way. Maintain a list of who's on, username, station and so on. A problem arises when you have an abnormal termination, power failuer or whatever, the table may not get updated.

Also, I have a utility I wrote to check for open files on a Windows server. Feel free to download it and try it out.
Follow the link by my signature and scroll down until you find 'Open File Lister'.
It can show everyone using any of your files by server, file name, username and so on. It can also clear connections if needed.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[Olaf Doschke]

Hi FoxWing,

due to the abnormal terminations Dave mentioned: let each user RLOCK() their own record. That lock will be unlocked even at abnormal termination, giving you a very good hint on whos "online".

Bye, Olaf.

 

[craigber]

RLOCKing can have adverse problems. If you do an UNLOCK ALL or UNLOCK in the wrong work area, the information is lost. See the article on my web site about limited simultaneous users. The same technique can be used here.

Craig Berntson
MCSD, Visual FoxPro MVP,

http://www.craigberntson.com

Author, CrysDev: A Developer's Guide to Integrating Crystal Reports"