ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / Managing HFSQL Client/Server
  • Overview
  • Differences specific to an HFSQL Client/Server application
  • Paths
  • WLanguage functions
  • Functions not available in an HFSQL Client/Server application
  • Notes
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
Differences and specific features of an HFSQL Client/Server application
HFSQL Client/ServerAvailable only with this kind of connection
Overview
The management mode of data files may have to be adapted when using an HFSQL Client/Server application.
Differences specific to an HFSQL Client/Server application

Paths

The paths specified in the following functions and properties must be relative to the database found on the server (database used in the connection). This operating mode allows you to be independent of the location of the server used.
For example, in the diagram below, the databases correspond to the following directories: "DataApplicationA", "DataApplicationB" and "DataApplicationC".
In this example, after the call to HChangeDir, the new access path to the data file named "Customer.fic" will be ".\DataAplicationA\Customer2004\Customer.fic".
HChangeDir(CUSTOMER, "Customer2004")
or
HChangeDir(CUSTOMER, ".\Customer2004")
DescribedDirectoryThe directory of the data file must be relative to the database found on the server.
DirectoryThe directory of the data file must be relative to the database found on the server.
HChangeDirThe access path to the data file must be relative to the database found on the server.
HDeclareExternalThe access path to the data file to import must be relative to the database found on the server.

WLanguage functions

The following functions have a different operating mode in an HFSQL Client/Server application:
HCreateViewThe hViewBreakable constant is not available in a WINDEV HFSQL Client/Server application.
The <Page Size> parameter is ignored.
HDeclareExternalThe syntax 3 (use with OLE DB/Native Access) is not available in a WINDEV HFSQL Client/Server application.
HListLinkThe name of the files found in <Result> corresponds to the name and to the relative path of these files.
HReadSeekThe hLimitParsing constant is not available in a WINDEV HFSQL Client/Server application.
Functions not available in an HFSQL Client/Server application
The following functions are not available in a HFSQL Client/Server application.
HChangeLocationHDBCreationHDBDescribeFile
HDBDescribeIndexHDBDescribeFieldHDBIndex
HDBOpenHDBOpenNoLockHDBSortType
HInitHF55HMigrateLinkedCompositeKeyHMode
HSecurity
The functions followed by the "*" character will be available in a forthcoming version.

Notes

Like in a WINDEV HFSQL Network application, the data handled by the following functions are supplied by the clients. Consequently, these data files must be found on the client computer (or they must be accessible by the client computer).
Therefore, the path of the data files is defined in relation to the client computer.
HDeclareThe analysis (".WDD" file) must be found on the client computer (or it must be accessible from the client computer).
HExportXMLThe XML file to generate must be found on the client computer (or it must be accessible from the client computer).
HExtractMemoThe file in which the item content will be saved must be found on the client computer (or it must be accessible from the client computer).
HImportHF55The file to import and the imported file must be found on the client computer (or they must be accessible from the client computer).
HImportTextThe text file must be found on the client computer (or it must be accessible from the client computer).
HImportXMLThe XML file must be found on the client computer (or it must be accessible from the client computer).
HInfoMemoThe attached file is found in the client computer (or it is accessible from the client computer).
HLinkMemoThe file to attach must be found on the client computer (or it must be accessible from the client computer).
HOpenAnalysisThe analysis (".WDD" file) must be found on the client computer (or it must be accessible from the client computer).
HSetREPThe ".REP" file must be found on the client computer (or it must be accessible from the client computer).
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 11/20/2023

Send a report | Local help