ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
HListConnectedUser (Function)
In french: HListeUtilisateurConnecté
HFSQL Client/ServerAvailable only with this kind of connection
Lists the users currently connected to one or more files handled by a Client/Server connection.
Example
// Describe the connection
HDescribeConnection("MyConnection", "Julia", "Password", "MyHFServer", "MyDatabase", ...
hAccessHFClientServer, hORead)
// Open the connection
HOpenConnection("MyConnection")
Result1 is string
Result1 = HListConnectedUser("MyConnection")
// Add the users into a List Box control
ListAdd(LIST_MyList, Result1)
Syntax
<Result> = HListConnectedUser(<Connection name> [, <Database> [, <Physical file name>]])
<Result>: Character string
Name of the different users who are using:
  • the specified 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 + ...

Remark: If the current user does not have the rights to see the users (hRightsSeeUser constant) on the server (HModifyServerRights or HInfoServerRights), HListConnectedUser returns the connections of the current user.
<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 and <Physical file name> are not specified, HListConnectedUser lists the users connected to the server.
<Physical file name>: Optional character string
Name of file for which we want to find out the connected users.
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: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/07/2023

Send a report | Local help