ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Native SQL Server Connector
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
HListProvider (Function)
In french: HListeProvider
OLE DBNative Connectors (Native Accesses)Available only with these kinds of connection
Returns the list of OLE DB providers and/or Native Connectors installed on the current computer.
Example
// Retrieve the list of Native Connectors
sNCList is string
sNCExtract is string
sDescription is string
nIndex is int = 1
sNCList = HListProvider()
LOOP
// Extract each Native Connector
sNCExtract = ExtractString(sNCList, nIndex, CR)
sDescription = ExtractString(sNCExtract, 1, TAB)
sNCExtract = ExtractString(sNCExtract, 2, TAB)
IF sNCExtract = EOT THEN BREAK
// Add Native Connector in the Combo Box control
ListAdd(COMBO_ChSupplier, sDescription + gStoredValue(sNCExtract))
nIndex++
END
Syntax
<Result> = HListProvider()
<Result>: Character string
List of providers and/or Native Connectors (also called Native Access) in the following format:
<Description of provider 1> + TAB + <Name of provider 1> + <CR> +...
<Description of provider n> + TAB + <Name of provider n> + <CR>
where
  • <Description of provider> corresponds to:
    • the generic name of the provider (Excel 2000 for example).
    • the name of the Native Connector.
    • a description extracted from the registry.
  • <Name of provider> corresponds to the constant that identifies the OLE DB provider or the Native Connector. This identifier can be used in the HFSQL functions (HOpenConnection, HDescribeConnection, ...).
Remarks
WINDEVWEBDEV - Server codeReports and QueriesWindowsLinuxUser code (UMC)AjaxNative Connectors (Native Accesses)

Native SQL Server Connector

HListProvider takes into account the value of H.SQLServerMode variable.
In default mode, if one of the two Native SQL Server Connectors is installed on the computer, the Native SQL Server Connector will be listed.
If the former Native Connector is forced (H.ModeSQLServer=2) and if it is not on the computer, the Native SQL Server Connector will not be listed.
If the new Native Connector is forced (H.ModeSQLServer=0), and if it is not on the computer, the Native SQL Server Connector will not be listed.
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: 06/04/2024

Send a report | Local help