|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| ...The reports can be created with the data coming from:... |
|
|
|
|
|
|
|
| Changes the mode and the method for locking data files. |
|
|
|
|
|
|
|
| Disables an automatic filter on the linked files when browsing an XML file. |
|
|
|
|
|
|
|
| Defines the WLanguage procedure that will be called whenever a replication operation is performed... |
|
|
|
|
|
|
|
| Declares a (1, 1) (0, n) link between two tables. |
|
|
|
|
|
|
|
| Used to find out the state of a record. |
|
|
|
|
|
|
|
| Automatically updates the controls of a page with:
the values of the bound items in the current... |
|
|
|
|
|
|
|
| This feature is used to signal that a data file cannot be modified after writing...... |
|
|
|
|
|
|
|
| The replication is the operation allowing you to keep updated remote databases of identical... |
|
|
|
|
|
|
|
| When working on a laptop computer or on an offline computer, you may want to continue working... |
|
|
|
|
|
|
|
| Returns the list of OLE DB providers and/or Native Connectors installed on the current computer.... |
|
|
|
|
|
|
|
| Displays a message on the Client computer(s) and disconnects the application. |
|
|
|
|
|
|
|
| Checks whether one or all records in an unalterable data file have not been modified... |
|
|
|
|
|
|
|
| Re-enables a server trigger that was disabled by HDeactivateServerTrigger. |
|
|
|
|
|
|
|
| Adds an integrity rule between two files on the server. |
|
|
|
|
|
|
|
| Reads a parameter that was saved from a stored procedure by HSaveParameter. |
|
|
|
|
|
|
|
| Used to immediately start the automatic server update. |
|
|
|
|
|
|
|
| Asks to recalculate the content of a materialized view. |
|
|
|
|
|
|
|
| Displays a message on the client computers. |
|
|
|
|
|
|
|
| Returns information about a materialized view. |
|
|
|
|
|
|
|
| Opens the xBase data file and the "memo" file if it exists. |
|
|
|
|
|
|
|
| Returns the quality level of connection: the higher the level is, the faster the connection will be. |
|
|
|
|
|
|
|
| Creates a text file containing the server logs between two given dates. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|