|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| A backup of an HFSQL Client/Server database can be restored at any time... |
|
|
|
|
|
|
|
| When creating the setup program of a WINDEV application using HFSQL Client/Server data files, the wizard allows you to... |
|
|
|
|
|
|
|
| You have the ability to create applications that access the HFSQL Client/Server databases... |
|
|
|
|
|
|
|
| An application using User Groupware can be used with a HyperFileSQL database in Client/Server mode... |
|
|
|
|
|
|
|
| Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis... |
|
|
|
|
|
|
|
| All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database... |
|
|
|
|
|
|
|
| This help page presents the main recommendations for optimizing the security and performance of an HFSQL Client/Server database according to the constraints and desired features... |
|
|
|
|
|
|
|
| An application that uses the User Groupware can be used with an HFSQL database in Client/Server mode... |
|
|
|
|
|
|
|
| The backup of the HFSQL Client/Server databases can be performed ... |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| Gets various statistics on the keys of an HFSQL Client/Server data file. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| This feature is used to signal that a data file cannot be modified after writing... |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server data file. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Displays a message on the client computers. |
|
|
|
|
|
|
|
| A server may encounter problems without any user (or developer) noticing anything. For example: - a scheduled task may fail,
- an automatic backup may fail,
- a node may become inactive in an HFSQL cluster, ...
|
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server data file. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| The following functions are used to manage an HFSQL cluster |
|
|
|
|
|
|
|
| Gets various statistics on the keys of an HFSQL Client/Server data file. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Displays a message on the client computers. |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server data file (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| WDLog allows you to save all the HFSQL data files used by a WINDEV or WEBDEV application... |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server data file (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Returns the list of users defined for a connection. |
|
|
|
|
|
|
|
| Returns the list of groups of users defined for a connection. |
|
|
|
|
|
|
|
| Creates or updates a set of procedures on an HFSQL server. |
|
|
|
|
|
|
|
| Returns information about the specified group of users. |
|
|
|
|
|
|
|
| Returns the characteristics of a scheduled task in a hScheduledTask variable]. |
|
|
|
|
|
|
|
| Modifies the information about a user according to the elements found in the corresponding variables for user management. |
|
|
|
|
|
|
|
| The purpose of universal replication is to keep several databases synchronized...... |
|
|
|
|
|
|
|
| Creates or updates a set of procedures on an HFSQL server. |
|
|
|
|
|
|
|
| Modifies the information about a user according to the elements found in the corresponding variables for user management. |
|
|
|
|
|
|
|
| Returns the characteristics of a scheduled task in a hScheduledTask variable]. |
|
|
|
|
|
|
|
| Returns information about the specified group of users. |
|
|
|
|
|
|
|
| Returns the list of groups of users defined for a connection. |
|
|
|
|
|
|
|
| Returns the list of users defined for a connection. |
|
|
|
|
|
|
|
| Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries). |
|
|
|
|
|
|
|
| The access speed to the data in network depends on several parameters (see the section...... |
|
|
|
|
|
|
|
| Lists the different triggers available on a connection or on one of the connection files. |
|
|
|
|
|
|
|
| Checks and optimizes the system tables of an HFSQL server. |
|
|
|
|
|
|
|
| The Secure property is used to configure the security level of data file encryption. |
|
|
|
|
|
|
|
| Initializes the structure for managing the Client computers (HClient structure). |
|
|
|
|
|
|
|
| Returns the list of current or interrupted transactions on the server for the specified connection. |
|
|
|
|
|
|
|
| Returns information about the lock set on a data file, on one or all the records in a data file. |
|
|
|
|
|
|
|
| Used to restore:
an immediate backup (performed by HBackup or via the HFSQL Control Center),
a scheduled backup (described by HAddScheduledBackup or via the HFSQL Control Center.... |
|
|
|
|
|
|
|
| Used to restore:
an immediate backup (performed by HBackup or via the HFSQL Control Center),
a scheduled backup (described by HAddScheduledBackup or via the HFSQL Control Center.... |
|
|
|
|
|
|
|
| Deletes (from the server) a group of users associated with a connection. |
|
|
|
|
|
|
|
| Cancels a current backup. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|