PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Overview
  • Differences specific to a HFSQL Client/Server application
  • Paths
  • WLanguage functions
  • Functions not available in a HFSQL Client/Server application
  • Notes
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
Differences and specific features of a 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 a HFSQL Client/Server application.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Differences specific to a 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")
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.
DirectoryThe directory of the data file must be relative to the database found on the server.
DescribedDirectoryThe directory of the data file must be relative to the database found on the server.

WLanguage functions

The following functions have a different operating mode in a HFSQL Client/Server application:
HDeclareExternalThe syntax 3 (use with OLE DB/Native Access) is not available in a WINDEV HFSQL Client/Server application.
HCreateViewThe hViewBreakable constant is not available in a WINDEV HFSQL Client/Server application.
The <Page Size> parameter is ignored.
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 a HFSQL Client/Server application
The following functions are not available in a HFSQL Client/Server application.
HChangeLocationHConnectRemoteAccess
HDBCreationHDBDescribeFileHDBDescribeIndex
HDBDescribeFieldHDBIndexHDBOpen
HDBOpenNoLockHDBSortTypeHSetRemoteAccess
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.
HLinkMemoThe file to attach must be found on the client computer (or it must be accessible from 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).
HSetREPThe ".REP" file 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).
HOpenAnalysisThe analysis (".WDD" file) must be found on the client computer (or it must be accessible from the client computer).
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment