|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The scheduled tasks are used to schedule automatic tasks... |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| To ensure data security and confidentiality, some actions may be restricted to a group of users... |
|
|
|
|
|
|
|
| When creating the setup program of a WINDEV application using HFSQL Client/Server data files, the wizard allows you to... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| The backup of the HFSQL Client/Server databases can be performed ... |
|
|
|
|
|
|
|
| The ports used by the HFSQL Client/Server server... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| 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 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 data file (.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 data file. This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2. |
|
|
|
|
|
|
|
| Kerberos is an authentication mode based on the use of tickets and secret keys... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Required configuration and overview for installing HFSQL Cluster. |
|
|
|
|
|
|
|
| The following functions are used to manage an HFSQL cluster |
|
|
|
|
|
|
|
| Adds an optimization task of HFSQL Client/Server data files. |
|
|
|
|
|
|
|
| HFSQL Cluster is a database server intended to be deployed on several servers... |
|
|
|
|
|
|
|
| Adds an optimization task of HFSQL Client/Server data files. |
|
|
|
|
|
|
|
| The server that is hosting a HFSQL database engine can be very busy... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| The stored procedures and the triggers are debugged from the environment, with real execution on the server... |
|
|
|
|
|
|
|
| List of HFSQL properties... |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Exports the records found in a data file (HFSQL or OLE DB), view or query to an XML file. |
|
|
|
|
|
|
|
| Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| The hScheduleMaterializedView type is used to programmatically manage a task for recalculating the data of a scheduled materialized view on an HFSQL server. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| The FilterCondition property allows you to know the selection condition set by HFilter on a data file, HFSQL view or query. |
|
|
|
|
|
|
|
| Creates an HFSQL view from two previously created views (HCreateView). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Indicates that a reindex operation is currently performed on an HFSQL data file and returns the percentage of reindexing already performed. |
|
|
|
|
|
|
|
| Indicates that a reindex operation is currently performed on an HFSQL data file and returns the percentage of reindexing already performed. |
|
|
|
|
|
|
|
| A query (typed in SQL code) can operate on different databases...... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc.... |
|
|
|
|
|
|
|
| Used to update the structure of an HFSQL data file by performing an automatic data modification (also called data synchronization). |
|
|
|
|
|
|
|
| Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc. |
|
|
|
|
|
|
|
| The FilterWithBounds property is used to determine if bounds have been specified for the filter implemented by HFilter on an HFSQL data file, view or query. |
|
|
|
|
|
|
|
| The DescribedName property is used to handle the logical name of HFSQL data files (ignoring possible changes made by HAlias). |
|
|
|
|
|
|
|
| Used to update the structure of an HFSQL data file by performing an automatic data modification (also called data synchronization). |
|
|
|
|
|
|
|
| Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc. |
|
|
|
|
|
|
|
| The SQL functions can be used to handle the ORACLE database, regardless of whether WDORAINS is used or not to configure the accessed database...... |
|
|
|
|
|
|
|
| Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password protected. |
|
|
|
|
|
|
|
| Populates a Table control programmatically with the records from a data file, HFSQL view or query (query created in the query editor or with HExecuteSQLQuery). |
|
|
|
|
|
|
|
| Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
|
|
|
|
|
|
|
| Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|