Sami,
We created a permanent table to store the information as to who is logged in.
You also end up with a history as to which people were logged on over time. The
commands run at the login screen. The table "User" has the following fields;
> UserID
> NetUserID
> EmployeeID
> FirstName
> LastName
> Password
> emailAddress
> LoginTime
> LogoutTime
> CreatedDate
> ModifiedDate
> ModifiedBY
update Users set LoginTime = (DateTime(.#DATE,.#TIME)), LogoutTime = null +
where UserID = .vgUserID
insert into UserLog (UserID, NetUserID, LogDate, LogTime, Location) +
values(.vgUserID, (cval('NETUSER')), .#Date, .#Time, (cval('COMPUTER')))
Myron
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Sami Aaron
Sent: Monday, June 06, 2005 10:34 AM
To: RBG7-L Mailing List
Subject: [RBG7-L] - RE: Logon list
Larry -
Is there a way to get the list of network logins that have the RB1 file open
and have it accessible to R:BASE in a variable?
And then is it possible to CLOSE the file from within an R:BASE command file
if the user has the appropriate server rights?
Sami
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence
Lustig
Sent: Monday, June 06, 2005 9:07 AM
To: RBG7-L Mailing List
Subject: [RBG7-L] - RE: Logon list
> I just create a date/time field, "EmpLoggedIn", in
> the table that tracks the user's name or login.
I do something similar, but I also capture the computer name logged in from
(CVAL('COMPUTER')) so that I can find the machine if the person has left.
Also, you can get from the server console a list of network logons that have
a
particular file (like the RB1 file) open.
--
Larry
