|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| The CaseSensitive property is used to determine if the different searches performed on the item distinguish between uppercase and lowercase characters (with HReadSeek, HReadSeekFirst and HReadSeekLast, for example). |
|
|
|
|
|
|
|
| The MinSourceCardinality property is used to get and modify the minimum cardinality of the source item in the link. |
|
|
|
|
|
|
|
| The LinkedKey property sets the characteristics of a link. |
|
|
|
|
|
|
|
| The MmoPackMethod property sets the compression mode of a MMO file (containing text and binary memos) associated with a data file. |
|
|
|
|
|
|
|
| The FicEncryption property is used to set the encryption method of a data file. |
|
|
|
|
|
|
|
| The MmoEncryption property is used to set the encryption method of the memo file (.MMO) associated with the data file. |
|
|
|
|
|
|
|
| The NdxEncryption property is used to configure the encryption method for the index (.NDX) file associated with the data file. |
|
|
|
|
|
|
|
| The Extension property is used to:
get the extension of a file defined in the data model editor or through programming.
define the extension of a file (when the file is described through programming only).... |
|
|
|
|
|
|
|
| The Format property is used to define the data format of a data file. |
|
|
|
|
|
|
|
| The HugeFile property is used to configure the maximum size of a data file. |
|
|
|
|
|
|
|
| NbArrayElement is used to configure the number of elements in an array item. |
|
|
|
|
|
|
|
| The AccentSensitive property is used to determine if accented characters are taken into account in the different searches performed on the item (with HReadSeek, HReadSeekFirst and HReadSeekLast, for example). |
|
|
|
|
|
|
|
| The MaxSourceCardinality property gets and changes the maximum cardinality of the source item in the link. |
|
|
|
|
|
|
|
| Enables or disables log management on a file. |
|
|
|
|
|
|
|
| Used to modify the management mode of memo items. |
|
|
|
|
|
|
|
| Defines the mode for comparing data files. |
|
|
|
|
|
|
|
| Modifies the search mode of physical data files (.FIC, .NDX, ...). |
|
|
|
|
|
|
|
| The MinimumLength property is used to configure the minimum length of the words to be indexed. |
|
|
|
|
|
|
|
| Describes a full-text index of data file created through programming. |
|
|
|
|
|
|
|
| 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 data file described in the data model editor.
the values of the bound WLanguage variables.
This operation is performed regardless of the state of the controls (grayed, inactive or invisible).... |
|
|
|
|
|
|
|
| Automatically updates:
the values of a data file's items in memory with the values from the controls in the window.
the value of the WLanguage variables with the value of the window controls.
This function is also available for WEBDEV pages.... |
|
|
|
|
|
|
|
| Automatically initializes:
the values of a data file's items in memory with the values from the controls in the window.
the value of the WLanguage variables with the value of the window controls.
This function is also available for WEBDEV pages.... |
|
|
|
|
|
|
|
| Automatically updates:
the values of a data file's items in memory with the values from the controls in the window.
the value of the WLanguage variables with the value of the window controls.
This function is also available for WEBDEV pages.... |
|
|
|
|
|
|
|
| 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 data file described in the data model editor.
the values of the bound WLanguage variables.
This operation is performed regardless of the state of the controls (grayed, inactive or invisible).... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|