|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A report based on an HFSQL view is used to print records from an HFSQL Classic or Client/Server view... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| An HFSQL context contains information relative to the data used... |
|
|
|
|
|
|
|
| List of functions for HFSQL management |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| Describes a table programmatically. |
|
|
|
|
|
|
|
| Declares a transaction savepoint. |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
| Describes a table programmatically. |
|
|
|
|
|
|
|
| Returns the full path of the directory of HFSQL tables specified by the user when installing the application. |
|
|
|
|
|
|
|
| A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ...) on a record of a table. |
|
|
|
|
|
|
|
| Returns the list of items: |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| WDHFDiff is a tool used to compare HFSQL tables... |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native DB2 Connector... |
|
|
|
|
|
|
|
| This document presents the different access modes to databases from a WINDEV Java application... |
|
|
|
|
|
|
|
| Link functions are used to link the interface with the tables and vice versa. These functions are as follows: |
|
|
|
|
|
|
|
| Checks whether the data found in the index table (.NDX file) properly refers the data found in the table (.FIC file). |
|
|
|
|
|
|
|
| Determines if a query has been executed. |
|
|
|
|
|
|
|
| Describes a full-text index of table created programmatically. |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access... |
|
|
|
|
|
|
|
| The comparison operators can be divided into several categories... |
|
|
|
|
|
|
|
| Defines the mode for comparing tables. |
|
|
|
|
|
|
|
| A filter is used to define through programming a selection of records corresponding to one or more criteria... |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL table. |
|
|
|
|
|
|
|
| A structure is a custom type of data... |
|
|
|
|
|
|
|
| Determines if a query has been executed. |
|
|
|
|
|
|
|
| Checks the structural integrity of memos in an HFSQL table. |
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
Validates the current transaction: - the modifications performed on the table since the start of transaction (HTransactionStart) are validated.
- the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
- the records locked in read-only by the transaction are unlocked.
|
|
|
|
|
|
|
|
| The File Description variable is used to programmatically describe tables. |
|
|
|
|
|
|
|
| Training FOR ALL instruction can be used to perform different types of runs... |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "normal" records if they do not belong to a transaction currently in progress. |
|
|
|
|
|
|
|
| "Password" items are used to securely store passwords by using a salt and a hash algorithm... |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction. |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Used to find out whether a transaction was interrupted (the transaction was neither validated nor canceled). |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
Validates the current transaction: - the modifications performed on the table since the start of transaction (HTransactionStart) are validated.
- the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
- the records locked in read-only by the transaction are unlocked.
|
|
|
|
|
|
|
|
| Exports the records found in a table (HFSQL or OLE DB), view or query to a JSON file. |
|
|
|
|
|
|
|
| Checks whether the data found in the index table (.NDX file) properly refers the data found in the table (.FIC file). |
|
|
|
|
|
|
|
| Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
|
| You can start developing your application as soon as the WINDEV project is defined as being a Java project... |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string. |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code... |
|
|
|
|
|
|
|
| Returns the list of stop words used by a full-text index. |
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
|
|
|
|
|
|
|
| Exports the records from a table (HFSQL or OLE DB), view, or query to a JSON string. |
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV offer an optional Native Connector to DB2... |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Defines the mode for comparing tables. |
|
|
|
|
|
|
|
| Automatically updates the controls of a page with:
the values of the bound items in the current... |
|
|
|
|
|
|
|
| Deletes a parameter previously saved by HSaveParameter. |
|
|
|
|
|
|
|
| The KeyExpression property is used to set the different components of a composite key. |
|
|
|
|
|
|
|
| A new GDPR audit is available to easily identify and monitor personal data in a WINDEV, WEBDEV... |
|
|
|
|
|
|
|
| Deletes a parameter previously saved by HSaveParameter. |
|
|
|
|
|
|
|
| Reads a parameter that was saved from a stored procedure by HSaveParameter. |
|
|
|
|
|
|
|
| Returns the quality level of connection: the higher the level is, the faster the connection will be. |
|
|
|
|
|
|
|
| Re-enables a server trigger that was disabled by HDeactivateServerTrigger. |
|
|
|
|
|
|
|
| Creates a text file containing the server logs between two given dates. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose a Native Connector to SQLite. This Native Connector allows you to access... |
|
|
|
|
|
|
|
| Returns information about a materialized view. |
|
|
|
|
|
|
|
| Used to immediately start the automatic server update. |
|
|
|
|
|
|
|
| Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
|
| Adds an integrity rule between two data files on the server. |
|
|
|
|
|
|
|
| Displays a message on the Client computer(s) and disconnects the application. |
|
|
|
|
|
|
|
| Displays a message on the client computers. |
|
|
|
|
|
|
|
| The principle for working with the Source Code Manager is as follows...... |
|
|
|
|
|
|
|
| Development cycle of a WINDEV application.... |
|
|
|
|
|
|
|
| You have the ability to use external languages with WINDEV...... |
|
|
|
|
|
|
|
| License agreement for the tools included with WINDEV, WEBDEV and WINDEV Mobile... |
|
|
|
|
|
|
|
| To create a Pivot Table control...... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV propose a Native Connector to MariaDB (also called Native Access)...... |
|
|
|
|
|
|
|
| The TimestampType property is used to:
Find out the type of timestamp for an item. This item... |
|
|
|
|
|
|
|
| The TimestampUTC property is used to:
Find out whether a timestamp item will use UTC time... |
|
|
|
|
|
|
|
| The CalculatedItemExpression property is used to:
Find out the SQL expression that defines... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|