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
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.
Example
// Display the accessible data sources in a list
ListAdd(LIST_DataList, SQLListSource())

// Display the accessible databases in a list
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.
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.
INFORMIXThe Native INFORMIX Access 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.
MYSQLThe Native MySQL Access 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.
POSTGRESQLThe Native POSTGRESQL Access is installed on the current computer.
PROGRESSThe Native PROGRESS Access 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.
SQL SERVERThe Native SQL SERVER Access is installed on the current computer.
Note: The value of H.SQLServerMode 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.
SYBASEThe Native SYBASE Access 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", ...
Components
WINDEVWEBDEV - Server codeReports and Queries wd230sql.dll
Linux wd230sql.so
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment