Kbase P164821: How many unique users are connected to the database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/04/2010 |
|
Status: Unverified
GOAL:
How many unique users are connected to the database?
GOAL:
How can I tell how many unique users are currently connected?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
OpenEdge Category: Language (4GL/ABL)
FIX:
The following code will give you a count of the number of unique users currently connected to the database.
define variable i as integer no-undo.
for each _connect no-lock where _connect-type <> ? break by _connect-name:
if first-of(_connect-name) then
do:
/* you can just do the i = i + 1 if you don't want to display the name */
i = i + 1.
display _connect-name.
end.
end.
display i.