|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 2025 - Update 2. |
|
|
|
|
|
|
|
| Deletes a user associated with a connection to the HFSQL server. |
|
|
|
|
|
|
|
| Starting with version 21, you can manage transactions in SQL code...... |
|
|
|
|
|
|
|
| Lists the HFSQL servers installed on a computer. |
|
|
|
|
|
|
|
| Deletes (from the server) a group of users associated with a connection. |
|
|
|
|
|
|
|
| Deletes a user associated with a connection to the HFSQL server. |
|
|
|
|
|
|
|
| Cancels a current backup. |
|
|
|
|
|
|
|
| Checks and optimizes the system tables of an HFSQL server. |
|
|
|
|
|
|
|
| Adds a scheduled task on the server defined by the connection. |
|
|
|
|
|
|
|
| Modifies a backup scheduling. |
|
|
|
|
|
|
|
| Deletes a backup previously created with HBackup. |
|
|
|
|
|
|
|
| Adds a scheduled task on the server defined by the connection. |
|
|
|
|
|
|
|
| Modifies a backup scheduling. |
|
|
|
|
|
|
|
| Deletes a backup previously created with HBackup. |
|
|
|
|
|
|
|
| The stored procedures and the triggers are debugged from the environment, with real execution on the server...... |
|
|
|
|
|
|
|
| Makes a backup copy of the content of an HFSQL server: all databases on the server, one or more databases, one or more data files. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| Starts tracking write actions (addition, modification or deletion) performed on a file found in an HFSQL server. |
|
|
|
|
|
|
|
| Stops tracking a data file on an HFSQL server. |
|
|
|
|
|
|
|
| Returns information about the server logs. |
|
|
|
|
|
|
|
| Deletes a server trigger. |
|
|
|
|
|
|
|
| Adds or modifies a server trigger. |
|
|
|
|
|
|
|
| Re-allows the access (which means the connection) to one or more databases accessible via a connection. |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|