ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Returns the list of connections currently described in the application:
  • connections described in the data model editor (for the main analysis and additional analyses if required).
  • connections described by programming (with functions HDescribeConnection or HOpenConnection).
Example
// Récupérer la liste des connexions
ListeCnx is string = HListeConnexion(hLstDetail + hLstAll + hLstSorted)

// Insérer la liste dans la combo COMBO_Connexion
ListAdd(COMBO_Connexion, ListeCnx)
Syntax
<Result> = HListConnection([<Options> [, <Connection delimiter> [, <Information delimiter>]]])
<Result>: Character string
List of connections defined in the current analysis and/or by programming.
Case of multi-analysis projects: If several analyses are in progress, all connections for all analyses in progress are listed (without duplicates).
The different connections are separated by a <Connection delimiter> (CR - Carriage Return - by default).
hLstDetail is not specified<Name of connection 1> + <Connection delimiter> + <Name of connection 2> + <Connection delimiter> +...
hLstDetail is specified<Name of connection 1> + <Information delimiter> + <User> + <Information delimiter> + <Data source> + <Information delimiter> + <Provider name> + <Information delimiter> + <Optional information> + <Connection delimiter> +...
<Options>: Optional Integer constant (or combination of constants)
Configures the type of list to perform:
hLstAllLists all the connections (connections of analysis and connections defined dynamically by HDescribeConnection or HOpenConnection).
hLstDetailDetailed information.
hLstNormal
(default value)
List of connections, not sorted, without the connections described programmatically.
hLstOpenedLists the opened connections only.
hLstSortedSorts the list in ascending order.
<Connection delimiter>: Optional character string
Delimiter used to separate the different connections. The default delimiter is a Carriage Return (CR).
<Information delimiter>: Optional character string
Delimiter used to separate the information returned about the connections. The default delimiter is the Tab character.
Business / UI classification: Business Logic
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/24/2024

Send a report | Local help