ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Displaying the result in a List Box or Combo Box control
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
Returns the list of connections currently described in the application. You have the ability list the connections described in the data model editor as well as the connections described through programming (with HDescribeConnection or HOpenConnection).
Example
// Retrieve the list of connections
CntList is string = HListConnection(hLstDetail + hLstAll + hLstSorted)
 
// Insert the list into COMBO_Connection
ListAdd(COMBO_Connection, CntList)
Syntax
<Result> = HListConnection([<Options> [, <Separator of connections> [, <Separator of information>]]])
<Result>: Character string
List of defined connections. The different connections are separated by the <Separator of connections> (CR - Carriage Return - by default).
hLstDetail is not specified<Name of connection 1> + <Separator of connections> + <Name of connection 2> + <Separator of connections> +...
hLstDetail is specified<Name of connection 1> + <Separator of information> + <User> + <Separator of information> + <Data source> + <Separator of information> + <Provider name> + <Separator of information> + <Optional information> + <Separator of connections> +...
<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 by programming.
hLstOpenedLists the opened connections only.
hLstSortedSorts the list in ascending order.
<Separator of connections>: Optional character string
Separator used to separate the different connections. This separator corresponds to a Carriage Return (CR) by default.
<Separator of information>: Optional character string
Separator used to separate the information returned about the connections. This separator corresponds to a tabulation - TAB - by default.
Remarks

Displaying the result in a List Box or Combo Box control

<Result> can be directly assigned to a List Box or Combo Box control by ListAdd. If the <Separator of connections> corresponds to CR, each row will contain the full name of one of the connections found.
Business / UI classification: Business Logic
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