PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
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
Lists the data sources declared on a local site. There is no need to be connected to the database to perform this operation.
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 24 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 24
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
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 Access is installed on the current computer.The Native DB2 Connector is installed on the current computer.
HYPER FILEAccess to HyperFileSQL databases.
Access to HFSQL databases.
Versions 21 and later
HIVE
New in version 21
HIVE
HIVE
The Native Hive Access is installed on the current computer.The Native Hive Connector is installed on the current computer.
INFORMIXThe Native INFORMIX Access is installed on the current computer.The Native INFORMIX Connector is installed on the current computer.
Versions 20 and later
MariaDB
New in version 20
MariaDB
MariaDB
The Native MariaDB Access is installed on the current computer.The Native MariaDB Connector is installed on the current computer.
MYSQLThe Native MySQL Access is installed on the current computer.The 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 Access is installed on the current computer.The Native ORACLE Connector is installed on the current computer.
POSTGRESQLThe Native POSTGRESQL Access is installed on the current computer.The Native POSTGRESQL Connector is installed on the current computer.
PROGRESSThe Native PROGRESS Access is installed on the current computer.The Native PROGRESS Connector is installed on the current computer.
Versions 16 and later
SQL AZURE
New in version 16
SQL AZURE
SQL AZURE
The Native SQL AZURE Access is installed on the current computer.The Native SQL AZURE Connector is installed on the current computer.
SQL SERVERThe Native SQL SERVER Access is installed on the current computer.
Note: The value of the H.SQLServerMode variable is taken into account. If the former native access is forced and not found on the computer, the native SQL Server access will not be listed. If the new native access is forced and if it is not found on the computer, the native SQL Server access will not be listed.
The Native SQL SERVER Connector is installed on the current computer.
Note: The value of H.SQLServerMode 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 Access is installed on the current computer.The 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 : wd250sql.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment