|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 SQL functions can be used to handle the SQL Server database...... |
|
|
|
|
|
|
|
| If your application is a multilingual application, the multilingual feature must also be managed in the windows/pages of user groupware...... |
|
|
|
|
|
|
|
| An application that works with the User Groupware can be used with a database handled by a Native Connector...... |
|
|
|
|
|
|
|
| This help page contains different programming tips for the User Groupware in WEBDEV...... |
|
|
|
|
|
|
|
| The User Groupware in automatic mode offers many possibilities...... |
|
|
|
|
|
|
|
| To specify the selection conditions in an SQL query, you can use...... |
|
|
|
|
|
|
|
| Runs the SQL code of a query created in the query editor. |
|
|
|
|
|
|
|
| The CalculatedDefaultValue property is used to:
Find out the SQL expression that defines the default value of an item. This item was defined in the data model editor or through programming.
Define the SQL expression that returns the default value of an item (item described through programming only).... |
|
|
|
|
|
|
|
| The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ...... |
|
|
|
|
|
|
|
| The LDAP protocol is increasingly used by the companies...... |
|
|
|
|
|
|
|
| The CalculatedItemExpression property is used to:
Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or through programming.
Define the SQL expression returning the value of a calculated item (when describing the item through programming).... |
|
|
|
|
|
|
|
| Cherche les éléments d'un noeud HTML correspondant à une balise.... |
|
|
|
|
|
|
|
| Initializes the different SQL variables with information relative to the last query run. |
|
|
|
|
|
|
|
| Allows you to specify the version of the Native SQL Server Connector that will be used. |
|
|
|
|
|
|
|
| The SQLCodeExecuted property gets the SQL code of a query after replacing the parameters with a value. |
|
|
|
|
|
|
|
| A Windows application, an Internet or Intranet site require to define the role of different contributors...... |
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| The groupware in automatic mode offers several possibilities...... |
|
|
|
|
|
|
|
| A script is a set of SQL commands used to perform a specific operation (create a new table in the database, insert records, ...... |
|
|
|
|
|
|
|
| Hive is a software layer of Hadoop used to run queries...... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQL Server Connector...... |
|
|
|
|
|
|
|
| SQL allows performing set operations on groups of files...... |
|
|
|
|
|
|
|
| List of SQL functions: Special case... |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code...... |
|
|
|
|
|
|
|
| You can create multilingual projects in WINDEV, WEBDEV or WINDEV Mobile...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|