|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Initializes the structure for user management (HUser) with the default values. |
|
|
|
|
|
|
|
| Modifies the group information according to the elements found in the corresponding variables for group management. |
|
|
|
|
|
|
|
| Modifies a scheduled task on the HFSQL server defined by the connection. |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or group of users on a server. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or to a group on a HFSQL server. |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on a database. |
|
|
|
|
|
|
|
| Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection. |
|
|
|
|
|
|
|
| Creates or updates a query on an HFSQL server. |
|
|
|
|
|
|
|
| Modifies the group information according to the elements found in the corresponding variables for group management. |
|
|
|
|
|
|
|
| Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection. |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or group of users on a server. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or to a group on an HFSQL server. |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on a database. |
|
|
|
|
|
|
|
| Customizes the management of message display on the client computer and the management of disconnection from a client computer. |
|
|
|
|
|
|
|
| Forces the execution of a scheduled backup. |
|
|
|
|
|
|
|
| Updates the variables for user management with the information regarding the specified user. |
|
|
|
|
|
|
|
| Deletes a set of stored procedures from an HFSQL server. |
|
|
|
|
|
|
|
| Returns the path of a temporary directory on the HFSQL server. |
|
|
|
|
|
|
|
| The HFSQL Control Center is used to create, configure and manage the replications between HFSQL servers.... |
|
|
|
|
|
|
|
| This chapter presents the following topics...... |
|
|
|
|
|
|
|
| Forces the execution of a scheduled backup. |
|
|
|
|
|
|
|
| Updates the variables for user management with the information regarding the specified user. |
|
|
|
|
|
|
|
| Deletes a set of stored procedures from an HFSQL server. |
|
|
|
|
|
|
|
| Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|