|
|
|
|
|
|
|
|
|
|
|
|
|
|
| To ensure data security and confidentiality, some actions may be restricted to a group of users... |
|
|
|
|
|
|
|
| The scheduled tasks are used to schedule automatic tasks... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| 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 ... |
|
|
|
|
|
|
|
| When creating the setup program of a WINDEV application using HFSQL Client/Server data files, the wizard allows you to... |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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, ...
|
|
|
|
|
|
|
|
| Required configuration and overview for installing HFSQL Cluster. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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 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. |
|
|
|
|
|
|
|
| The stored procedures and the triggers are debugged from the environment, with real execution on the server... |
|
|
|
|
|
|
|
| The database can be accessed via a web service...... |
|
|
|
|
|
|
|
| The use of SQL functions to handle DB2 data does not require importing the file structure into the analysis...... |
|
|
|
|
|
|
|
| The use of SQL functions to handle SQLite data does not require importing the data file structure into the analysis.... |
|
|
|
|
|
|
|
| A select query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| The LanguageDescribed property is used to set the language used to compare and sort Unicode items (Unicode Text item or Unicode Text Memo item). |
|
|
|
|
|
|
|
| The Language property is used to set the language used to compare and sort Unicode items (Unicode Text item or Unicode Text Memo item). |
|
|
|
|
|
|
|
| Retrieves the value of the current record before the trigger(s) are executed. |
|
|
|
|
|
|
|
| The TransactionFile property is used to determine if a data file is a transaction file. |
|
|
|
|
|
|
|
| Creates a color from its hue, saturation and lightness. |
|
|
|
|
|
|
|
| Associates the data directory specified in the analysis with a directory found on disk. |
|
|
|
|
|
|
|
| Returns the status of each cluster node by interrogating the coordinator. |
|
|
|
|
|
|
|
| The VisibleEndUser property is used to:
Find out whether an item is visible or not to the end users. This item was defined in the data model editor or programmatically.
Define whether an item must be visible or not to the end users (item described programmatically only).... |
|
|
|
|
|
|
|
| A "spare" server is a target server in a unidirectional automatic replication...... |
|
|
|
|
|
|
|
| Asks to recalculate the content of a materialized view. |
|
|
|
|
|
|
|
| Two methods can be used to create a query...... |
|
|
|
|
|
|
|
| The NewRecord property is used to determine if the record is a new record or if it comes from the data file. |
|
|
|
|
|
|
|
| Stores a unique computer number or identifier in order to use the log and transactions over the network. |
|
|
|
|
|
|
|
| The Binary property is used to determine if an item is binary. |
|
|
|
|
|
|
|
| The CtDescribedAccess property is used to set the type of access to the data file when connecting to a specific table via OLE DB. |
|
|
|
|
|
|
|
| The CtDatabase property is used to set the OLE DB data source when connecting to a specific table via OLE DB. |
|
|
|
|
|
|
|
| The CtDescribedDatabase property is used to set the OLE DB data source when connecting to a specific table via OLE DB. |
|
|
|
|
|
|
|
| The CtDescribedCaption property is used to get and set the caption of the connection to the OLE DB data source. |
|
|
|
|
|
|
|
| The CtDescribedPassword property allows you to set the password used to open the data file in an OLE DB connection (file defined in the code only). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|