PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Native SQL Server Access
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
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 the list of Native Accesses installed on the current computer.
Note: 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, ...)
Remarks
Reports and QueriesWindowsNative Connectors (Native Accesses)

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.
Component : wd240hf.dll
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment