General information
Category:
Coding, syntax & commands
Hi!
I asked this question a while ago and got some good advise...
My strategy was to...
Create a folder on the server containing a seperate folder for each user.
Example:
Profiles
-User1
foxuser.dbf
foxuser.fpt
-User2
foxuser.dbf
foxuser.fpt
When a user logs in they get their own personal foxuser.dbf file..
Via SET RESOURCE TO....
When they log out or the program crashes..
Their foxuser file is automatically deleted
The only trick was that NT seems to do something funny with the files:
And locks the ftp file longer then would be expexted
SO:
I use the open files function by Paul Vlad Tatavu
See FAQ#7896
And check how which FOXUSER.DBF's are locked and then from the folder name I have the user
that is in the system.
Note: do not check the ftp file becuase it doesn't always give the right results...
If using a client server application:
For example Oracle it's very simple:
SQLEXEC(h,"Select * from v$session","usersin")
Note: I also use this to see how many concurrent users are in the application...
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only