|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code... |
|
|
|
|
|
|
|
| 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 backup of the HFSQL Client/Server databases can be performed ... |
|
|
|
|
|
|
|
| The scheduled tasks are used to schedule automatic tasks... |
|
|
|
|
|
|
|
| A backup of an HFSQL Client/Server database can be restored at any time... |
|
|
|
|
|
|
|
| The ports used by the HFSQL Client/Server server... |
|
|
|
|
|
|
|
| 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 tables, the wizard allows you to... |
|
|
|
|
|
|
|
| Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis... |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| HFSQL Cluster is a database server intended to be deployed on several servers... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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, ...
|
|
|
|
|
|
|
|
| The following functions are used to manage an HFSQL cluster |
|
|
|
|
|
|
|
| A structure is a custom type of data... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| The server that is hosting a HFSQL database engine can be very busy... |
|
|
|
|
|
|
|
| All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database... |
|
|
|
|
|
|
|
| The stored procedures and the triggers are debugged from the environment, with real execution on the server... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Kerberos is an authentication mode based on the use of tickets and secret keys... |
|
|
|
|
|
|
|
| Required configuration and overview for installing HFSQL Cluster. |
|
|
|
|
|
|
|
| Adds an optimization task of HFSQL Client/Server tables. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Adds an optimization task of HFSQL Client/Server tables. |
|
|
|
|
|
|
|
| The queries are used to easily select the records coming from one or more files, matching one or more selection criteria, ...... |
|
|
|
|
|
|
|
| Before you start using WDConver, you must have...... |
|
|
|
|
|
|
|
| Returns a directory path for the shared data of the current application:
between all the users of the computer
between all the TSE users
This directory can be used without restriction in Windows XP, Vista, ... This directory is used to store:
the files for the general configuration of the application (.INI files, .XML files, etc.).
the data files common to all the users (HFSQL .fic, .ndx and .mmo files).... |
|
|
|
|
|
|
|
| The query editor is used to automatically create queries on the data files...... |
|
|
|
|
|
|
|
| The CacheSize property is used to:
Get the maximum number of records that can be stored in the cache of the Native MySQL Connector.
Change the maximum number of records that can be stored in the cache of the Native MySQL Connector.... |
|
|
|
|
|
|
|
| WDMap can be used both to determine whether an HFSQL table should be reindexed and to reindex an HFSQL table...... |
|
|
|
|
|
|
|
| The comparison between source and target text helps you find translation errors...... |
|
|
|
|
|
|
|
| Automatically initializes the controls of a window with:
the values of the bound items in the current record (loaded in memory) of the HFSL table described in the data model editor.
the values of the bound WLanguage variables.... |
|
|
|
|
|
|
|
| Automatically initializes the controls of a window with:
the values of the bound items in the current record (loaded in memory) of the HFSL table described in the data model editor.
the values of the bound WLanguage variables.... |
|
|
|
|
|
|
|
| Automatically updates the controls of a page with:
the values of the bound items in the current record (loaded in memory) of the HFSL table described in the data model editor.
the values of the bound WLanguage variables.... |
|
|
|
|
|
|
|
| Automatically initializes the controls of a window with:
the values of the bound items in the current record (loaded in memory) of the HFSL table described in the data model editor.
the values of the bound WLanguage variables.... |
|
|
|
|
|
|
|
| Automatically updates the controls of a page with:
the values of the bound items in the current record (loaded in memory) of the HFSL table described in the data model editor.
the values of the bound WLanguage variables.... |
|
|
|
|
|
|
|
| The replication between HFSQL servers consists in automatically replicating the data from server to server, in an asynchronous way...... |
|
|
|
|
|
|
|
| The "Key" items are used to organize the records in a table in order to optimize the browse or the search...... |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile allow you to manage the NULL value in the items of the HFSQL data files and for all the other types of accesses (Native, OLE DB, ...... |
|
|
|
|
|
|
|
| Automatically updates the controls in a window or page with:
the values of the bound items in the current record (loaded in memory) of the HFSL table described in the data model editor.
the values of the bound WLanguage variables.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|