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 AccessesAvailable 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.
Windows Mobile Only the list of Native Accesses is returned.
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, ...)
Windows Mobile Only the list of Native Accesses is available.
Remarks
WINDEVWEBDEV - Server codeReports and QueriesWindowsLinuxAjaxUser code (UMC)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.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Linux wd230hf.so
Windows Mobile wp230hf.dll
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment