HListConnectedUser (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HListConnectedUser (Function)

In french: HListeUtilisateurConnecté

Available only with this kind of connection

Lists users currently connected to one or more data files handled by a Client/Server connection.

Example

// Description de la connexion
HDescribeConnection("MaConnexion", "Julie", "MotDePasse", "MonServeurHF", "MaBaseDeDonnées", ...
	hAccessHFClientServer, hORead)
// Ouverture de la connexion
HOpenConnection("MaConnexion")
Résultat1 is string
Résultat1 = HListConnectedUser("MaConnexion")
// Ajout des utilisateurs dans un champ Liste
ListAdd(LISTE_Maliste, Résultat1)

Syntax

<Result> = HListConnectedUser(<Connection name> [, <Database> [, <Physical name of the data file>]])

<Result>: Character string

Name of the different users who are using:
or the specified data file.
the specified database.
If only the connection name is specified, lists all the users connected to the server.

The information is returned in the following format:
<Username> + TAB + <Name of client computer> + TAB +
<Name of client application> + TAB + <Internal version of client HFSQL library> +
TAB + <Version of client HFSQL library> + TAB +
<Priority of client application> + TAB +
<Name of server node (if HFSQL cluster)> + <IP address of client computer> + CR + ...

Note If the current user does not have user view rights (constant hRightViewUser) on the server (function HModifyServerRights or HInfoServerRights), the function HListConnectedUser function returns only the current user's connections.

<Connection name>: Character string

Name of the connection used. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.

<Database>: Optional character string

Name of database for which we want to find out the connected users.
If this parameter as well as the parameter <Physical name of the data file> are not specified, the function HListConnectedUser will list the users connected to the server.

<Physical name of the data file>: Optional character string

Name of the data file for which we want to know which users are currently logged in.
If this parameter is not specified, HListConnectedUser lists the users connected to the database.
If this parameter and <Database> are not specified, HListConnectedUser lists the users connected to the server.

Component: wd300hf.dll