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 !

Gunnar Ekblad

 

-----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.

Reply via email to