Bob
You mean like RBADMIN? However
I would not like the SY5 file back, that was a constant pain.
Timeout is great I agree
but it does not help when a crisis is at hand. And I must confess sometimes I
have crises at hand when I have to get users off NOW !
-----Original
Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: den 16 november
2004 17:18
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re:
Connections
I second that request. desoite the occasional
problems, I used to like the little utility where you could bump off users for
maintenance, and see who was still on.
I
tend to use the GREAT timeout function a lot to make sure things are not left
open at night and this helps sometimes.
Bob
C.
|
"Gunnar Ekblad"
<[EMAIL PROTECTED]>
Sent
by: [EMAIL PROTECTED]
11/16/2004 09:32 AM
|
Please
respond to
[EMAIL PROTECTED]
|
|
|
To
|
[EMAIL PROTECTED] (RBG7-L Mailing List)
|
|
cc
|
|
|
Subject
|
[RBG7-L] - Re: Connections
|
|
Razzak
A nice feature request for >= 7.5 would be
something like :
SET VAR Vconnectedusers = (cval('Connected
users'))
Returning a textstring of UserID/NetworkID
example:
'David,Razzak,Sharon,Mark,Mike'
That way I would have tool to findout which
workstation I need to ask to
exit when I need to do database maintenance.
Gunnar Ekblad
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of A. Razzak
Memon
Sent: den 16 november 2004 15:20
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re: Connections
At 08:31 AM 11/16/2004 -0500, David Blocker wrote:
>SET VAR vConnections = (CVAL('Connections'))
>
>It returns a text variable with the number of
current
>users connected to the database.
To return the variable as INTEGER, you may try the
following technique:
SET VAR vConnections = (INT(CVAL('Connections')))
That way you'll always get INTEGER value!
Very Best R:egards,
Razzak.