ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / Managing HFSQL Client/Server
  • Overview
  • Remarks
  • Important
  • Managing the integrity constraints
  • Importing the structures
  • Limitations
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
Overview
If you modify an existing WINDEV application into an HFSQL Client/Server application, two methods can be used to convert the HFSQL Classic files into HFSQL Client/Server files: from the data model editor or from the HFSQL Control Center. For more details on how to convert HFSQL Classic files to Client/Server, see Converting an HFSQL Classic database into HFSQL Client/Server.
No specific operation is required to create an HFSQL Client/Server application. The data files will be created on the server during the call to HCreation or HCreationIfNotFound.
Remarks

Important

In HFSQL Client/Server:
  • HSubstDir is ignored. Indeed, this function can only be used to substitute the directories of the HFSQL Network files.
  • If HChangeDir is used, you must specify a path relative to the directory of the application database on the server. This operating mode allows you to be independent of the location of the server used.
  • If a directory path is specified in the analysis description, in the description of the data files found in the analysis or in the project description, this path must be relative to the directory of the application database on the server.
  • The data files accessed by an HFSQL server are accessible via this server only. They cannot be directly accessed by another application especially via the HFSQL Classic engine. A connection to the server is required to access these data files.

Managing the integrity constraints

If an ISAM HFSQL application was modified into an HFSQL Client/Server application by creating the data files on the server, the integrity constraints are supported.
If an ISAM HFSQL application was modified into an HFSQL Client/Server application without creating the HFSQL data files on the server (by simple copy), the integrity constraints are not managed.
Several methods can be used to manage the integrity constraints in your HFSQL application:
  • Use the HAddLink function.
  • Perform the automatic modification of the data files when installing the application. The automatic modification of the data files is used to create the integrity constraints on the server.
Importing the structures
The structures of the files found on an existing HFSQL server can be imported into an analysis: on the "Analysis" tab, in the "Creation" group, expand "Import" and select "Import file/table descriptions...".
Limitations
The management mode of data files may have to be adapted when using an HFSQL Client/Server application. To learn more about the specific features to be taken into account, see Differences and limitations specific to an HFSQL Client/Server application.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help