|
|
|
|
- Overview
- Remarks
- Names on a Linux server
- Important
- Managing the integrity constraints
- Importing the structures
- Limitations
HFSQL Client/Server: Configuring the data files on the server
Available only with this kind of connection
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. 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.
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...".
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|