ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / SQL 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
Lists the data sources declared on a local site. There is no need to be connected to the database to perform this operation.
Example
// Display the accessible sources in a List Box control
ListAdd(LIST_DataList, SQLListSource())
 
// Display the accessible databases in a List Box control
ListAdd(LIST_DataList, SQLListSource("DATABASE"))
Syntax

Listing the data sources available for all the databases Hide the details

<Result> = SQLListSource()
<Result>: Character string
List of all available data sources. The different elements are separated by CR characters and they can be directly added into a list (ListAdd).
ODBC List of all the data sources defined in the ODBC administrator of the current computer.

Listing the available databases Hide the details

<Result> = SQLListSource(<"DATABASE">)
<Result>: Character string
List of all the types of databases available on the current computer. The different elements are separated by CR characters and they can be directly added into a list (ListAdd). The possible types of databases are:
ACCESSThe Microsoft Jet 4 provider as well as MDAC are installed on the current computer.
DB2The Native DB2 Connector is installed on the current computer.
HYPER FILEAccess to HFSQL databases.
HIVEThe Native Hive Connector is installed on the current computer.
INFORMIXThe Native INFORMIX Connector is installed on the current computer.
MariaDBThe Native MariaDB Connector is installed on the current computer.
MYSQLThe Native MYSQL Connector is installed on the current computer.
ODBCThe ODBC32 DLL is installed on the current computer.
OLEDBMDAC is installed on the current computer.
ORACLEThe Native ORACLE Connector is installed on the current computer.
POSTGRESQLThe Native POSTGRESQL Connector is installed on the current computer.
PROGRESSThe Native PROGRESS Connector is installed on the current computer.
SQL AZUREThe Native SQL AZURE Connector is installed on the current computer.
SQL SERVERThe Native SQL SERVER Connector is installed on the current computer.
Remark: The value of the H.SQLServerMode variable is taken into account. If the former Native Connector is forced and if it is not on the computer, the Native SQL Server Connector will not be listed. If the new Native Connector is forced and if it is not on the computer, the Native SQL Server Connector will not be listed.
SYBASEThe Native SYBASE Connector is installed on the current computer.
<"DATABASE">: Character string
"DATABASE": Character string used to list the databases available on the current computer.

Listing the data source available for a specific type Hide the details

<Result> = SQLListSource(<"DATABASE"> , <Type of database>)
<Result>: Character string
List of all data sources available for the specified type. The different elements are separated by CR characters and they can be directly added into a list (ListAdd). The possible results according to the type of database are as follows:
AccessEmpty string.
HYPER FILEEmpty string. We recommend that you use HListAnalysis to get the list of analyses.
ODBCList of ODBC databases defined in the ODBC administrator of current computer.
OLEDBEmpty string.
<"DATABASE">: Character string
"DATABASE": Character string used to list the data sources available for a specific type.
<Type of database>: Character string
Type of sought databases: "ODBC", ...
Component: wd290sql.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help