|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A Table, List Box or Combo Box control can be used to display the content of a data file or query...... |
|
|
|
|
|
|
|
| A Table control can be used to display the content of a data file or query...... |
|
|
|
|
|
|
|
| A query is used to interrogate a database in order to view, insert, modify or delete data...... |
|
|
|
|
|
|
|
| Queries can be based on items from another query...... |
|
|
|
|
|
|
|
| The query editor is used to automatically create queries on the data files...... |
|
|
|
|
|
|
|
| This help page presents the specific features of the user version of query editor...... |
|
|
|
|
|
|
|
| A query is used to request information from a database to view, insert, change or delete data.... |
|
|
|
|
|
|
|
| The queries are used to easily select the records coming from one or more files, matching one or more selection criteria, ...... |
|
|
|
|
|
|
|
| A sub-query is a query whose result is used by another query...... |
|
|
|
|
|
|
|
| WINDEV allows you to easily run queries in SQL code...... |
|
|
|
|
|
|
|
| The query editor allows you to easily handle the queries.... |
|
|
|
|
|
|
|
| When several data files are used in a query, the query editor automatically searches for the links between these files described in the analysis...... |
|
|
|
|
|
|
|
| The query editor proposes two methods for creating a query...... |
|
|
|
|
|
|
|
| This help page explains how to create two select queries...... |
|
|
|
|
|
|
|
| Reports & Queries is used to...... |
|
|
|
|
|
|
|
| The description window of a combining query consists of several sections...... |
|
|
|
|
|
|
|
| The query editor automatically creates a technical documentation for each query...... |
|
|
|
|
|
|
|
| To select records coming from several data files, joins must be used in the SQL query...... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Two methods can be used to create a query...... |
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ...... |
|
|
|
|
|
|
|
| Returns the list of parameters for a query created in the query editor. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|