HListProvider (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Native SQL Server Access

HCreateMoveableReplica

HCreateSubscriberReplica

HDeactivateAutoFilter

HDescribeFullTextIndex

HErrorStatusModification

HFilterIncludedBetween

HMigrateLinkedCompositeKey

HRecreateSubscriberReplica

Native SQL Server Access

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 the list of Native Accesses installed on the current computer.

Only the list of Native Accesses is returned.

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

Example

// Retrieve the list of native accesses
sNAList is string
sNAExtract is string
sDescription is string
nSubscript is int = 1
sNAList = HListProvider()
LOOP
        // Extract each native access
        sNAExtract = ExtractString(sNAList, nSubscript, CR)
        sDescription = ExtractString(sNAExtract, 1, TAB)
        sNAExtract = ExtractString(sNAExtract, 2, TAB)
        IF sNAExtract = EOT THEN BREAK
        // Add the native access into the combo box
        ListAdd(COMBO_ChSupplier, sDescription + gLink(sNAExtract))
        nSubscript++
END

Syntax

<Result> = HListProvider()

<Result>: Character string

List of providers and/or list of Native Accesses 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 provider (Excel 2000 for example).
the name of Native Access.
a description extracted from the registry.
<Name of Provider> corresponds to the constant identifying the OLE DB provider or the native access. This identifier can be used in the HFSQL functions (HOpenConnection, HDescribeConnection, ...)
Only the list of Native Accesses is available.

Remarks

Native SQL Server Access

HListProvider takes into account the value of H.SQLServerMode variable.

In default mode, if one of the two native SQL Server accesses is installed on the computer, the native SQL Server access will be listed.

If the former native access is forced (H.SQLServerMode=2) and if it is not found on the computer, the native SQL Server access will not be listed.

If the new native access is forced (H.SQLServerMode=0) and if it is not found on the computer, the native SQL Server access will not be listed.

Business / UI classification : Business Logic

Component : wd250hf.dll