HListProvider (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Native SQL Server Connector

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HExecuteQuery

HExecuteQueryAsynchronous

HExecuteSQLQuery

HExecuteSQLQueryAsynchronous

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

Native SQL Server Connector

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HListProvider (Function)

In french: HListeProvider

Available only with these kinds of connection

Returns the list of OLE DB providers and/or Native Connectors installed on the current computer.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

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

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: wd270hf.dll