|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ... |
|
|
|
|
|
|
|
| Two methods can be used to create a query... |
|
|
|
|
|
|
|
| An Update query (SQL UPDATE statement) is used to modify the records in a database file... |
|
|
|
|
|
|
|
| To make the result of a query easier to read, the records can be sorted according to one or more items... |
|
|
|
|
|
|
|
| In the result of a select query, you have the ability to only display... |
|
|
|
|
|
|
|
| The description window of a select query includes several sections... |
|
|
|
|
|
|
|
| The query editor allows you to perform operations on the values of an item... |
|
|
|
|
|
|
|
| The query editor proposes two methods for creating a query... |
|
|
|
|
|
|
|
| A query created in the query editor can contain several types of items... |
|
|
|
|
|
|
|
| A select query (corresponding SQL statement... |
|
|
|
|
|
|
|
| The project comparator is used to compare two elements and to list the differences found... |
|
|
|
|
|
|
|
| This help page explains how to create two select queries... |
|
|
|
|
|
|
|
| When a "Date" item is found in the query, you have the ability to only select the records corresponding to a given period... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| When creating and developing the different elements of a project (window, query, report, project, ... |
|
|
|
|
|
|
|
| A delete query (corresponding SQL statement... |
|
|
|
|
|
|
|
| The query editor allows you to optimize the execution speed of one or more queries... |
|
|
|
|
|
|
|
| When creating a class in the code editor, the Constructor and Destructor methods are automatically created by default... |
|
|
|
|
|
|
|
| Returns the list of parameters for a query created in the query editor. |
|
|
|
|
|
|
|
| Runs the SQL code of a query created in the query editor. |
|
|
|
|
|
|
|
| Returns the list of parameters for a query created in the query editor. |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| The SQLCode code property is used to get the SQL code of a query created with the query editor (".WDR" file). |
|
|
|
|
|
|
|
| When several data files are used in a query, the query editor automatically searches for the links between these files described in the analysis...... |
|
|
|
|
|
|
|
| This help page presents the specific features of the user version of query editor...... |
|
|
|
|
|
|
|
| Populates a Table control programmatically with the records from a data file, HFSQL view or query (query created in the query editor or with HExecuteSQLQuery). |
|
|
|
|
|
|
|
| A query is used to interrogate a database in order to view, insert, modify or delete data...... |
|
|
|
|
|
|
|
| The query editor allows you to easily handle the queries.... |
|
|
|
|
|
|
|
| This help page explains how to create and run an SQL query through programming.... |
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement...... |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code...... |
|
|
|
|
|
|
|
| List of HFSQL properties... |
|
|
|
|
|
|
|
| This help page explains how to create an SQL query to filter records.... |
|
|
|
|
|
|
|
| This help page explains how to create a query with a calculation formula with the query editor.... |
|
|
|
|
|
|
|
| In SQL language, an external join is used to exclude or include file records with or without correspondences in the linked files...... |
|
|
|
|
|
|
|
| This help page explains how to create a sort query with the query editor.... |
|
|
|
|
|
|
|
| This help page explains how to create a Sum query with the query editor.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|