PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Versions 22 and later
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 22
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
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:
Before version 15:
<User Name> + 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> + CR +...
From version 15 (internal version 150061 + setup pack of HFSQL Cluster), the name of the server node is added at the end of string:
<User Name> + 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> + CR +...
<User Name> + 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)> + CR + ...

Note: 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 (with or without quotes)
Name of 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.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment