|
|
|
|
|
|
|
|
|
|
|
|
|
|
| When creating the setup program of a WINDEV application using HFSQL Client/Server tables, the wizard allows you to... |
|
|
|
|
|
|
|
| Applications using the User Groupware are compatible with HFSQL databases in Client/Server mode... |
|
|
|
|
|
|
|
| The backup of the HFSQL Client/Server databases can be performed ... |
|
|
|
|
|
|
|
| A backup of an HFSQL Client/Server database can be restored at any time... |
|
|
|
|
|
|
|
| All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database... |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| You have the ability to create applications that access the HFSQL Client/Server databases... |
|
|
|
|
|
|
|
| An application that uses the User Groupware can be used with an HFSQL database in Client/Server mode... |
|
|
|
|
|
|
|
| Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis... |
|
|
|
|
|
|
|
| Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates. |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server table (".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. |
|
|
|
|
|
|
|
| The server that is hosting a HFSQL database engine can be very busy... |
|
|
|
|
|
|
|
| This feature is used to signal that a table cannot be modified after writing... |
|
|
|
|
|
|
|
| Gets various statistics on the keys of an HFSQL Client/Server table. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| 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, ...
|
|
|
|
|
|
|
|
| WDLog allows you to save all the HFSQL tables used by a WINDEV or WEBDEV application... |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| The following functions are used to manage an HFSQL cluster |
|
|
|
|
|
|
|
| Displays a message on the client computers. |
|
|
|
|
|
|
|
| Displays a message on the client computers. |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server table. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Rebuilds the index of an HFSQL Client/Server table (".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. |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL Client/Server table. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates. |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server table (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Gets various statistics on the keys of an HFSQL Client/Server table. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| The remote HFSQL administrator is a WEBDEV site installed with the WEBDEV application server and used to remotely manage the HFSQL Client/Server databases installed on the Web server... |
|
|
|
|
|
|
|
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server table (.FIC file). This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Used to find out the properties of a database on an HFSQL server. |
|
|
|
|
|
|
|
| Modifies the priority of a client application. |
|
|
|
|
|
|
|
| Returns the list of parameters saved from the stored procedures on the server. |
|
|
|
|
|
|
|
| Deletes the HFSQL data files (.fic, .ndx, .ftx and .mmo files if they exist) from the server. |
|
|
|
|
|
|
|
| Finds out and modifies the priority of the calling application. |
|
|
|
|
|
|
|
| Allows you to find out the properties of a data file located in an HFSQL server. |
|
|
|
|
|
|
|
| Allows you to find out the properties of an HFSQL server. |
|
|
|
|
|
|
|
| Modifies a scheduled optimization task on the HFSQL server defined by the connection. |
|
|
|
|
|
|
|
| Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view. |
|
|
|
|
|
|
|
| Delete a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| Lists scheduled elements defined on an HFSQL server: scheduled tasks (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| Data masking is a process that transforms the data in an item that will be displayed to the user...... |
|
|
|
|
|
|
|
| Returns the list of connections currently described in the application:
connections described in the data model editor (for the main database schema and, if necessary, additional database schemas).
connections described by programming (with functions HDescribeConnection or HOpenConnection).... |
|
|
|
|
|
|
|
| Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server. |
|
|
|
|
|
|
|
| Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|