PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Notes
  • Names on a Linux server
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
If you modify an existing WINDEV application into a HFSQL Client/Server application, the following steps are required to retrieve the HFSQL Network data files:
  • Creating the empty data files (HCreation or HCreationIfNotFound) on the server. This operation is used to define the integrity rules on the server.
  • In the HFSQL Control Center, selecting "Import a database". This option is used to copy the data files to the server (in the directory of the application database defined during the connection). During this copy, that data files created during the previous step will be overwritten.
If you modify an existing WINDEV application into a 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. See Converting a HFSQL Classic database into HFSQL Client/Server for more details.
No specific operation is required to create a HFSQL Client/Server application. The data files will be created on the server during the call to HCreation or HCreationIfNotFound.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Notes
WINDEVWEBDEV - Server codeLinux

Names on a Linux server

On a Linux server, the names of data files must be written in lowercase with no accented characters.
Therefore, the file named "Tasks.fic" must be renamed to "tasks.fic". HCopyFile is used to copy the data files while taking into account the specific features regarding the case of file names in Linux.

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 a 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 a HFSQL ISAM application was modified into a HFSQL Client/Server application by creating the data files on the server, the integrity constraints are supported.
If a HFSQL ISAM application was modified into a 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 HAddLink.
  • 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 HyperFileSQL server can be imported into an analysis ("Structure of files .. Import the file/table descriptions").The structures of the files found on an existing HFSQL server can be imported into an analysis: on the "Analysis" pane, in the "Creation" group, expand "Import" and select "Import the descriptions of files/tables".
Limitations
The management mode of data files may have to be adapted when using a HFSQL Client/Server application. See Differences and limitations specific to a HFSQL Client/Server application for more details.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment