Table, List Box and Combo Box controls bound to queries A Table, List Box or Combo Box control can be used to display the content of a data file or query...... Linking a Table control to a data file or query A Table control can be used to display the content of a data file or query...... Query and project The user version of query editor (Reports & Queries) A query is used to interrogate a database in order to view, insert, modify or delete data...... Query based on query Queries can be based on items from another query...... Query editor The query editor is used to automatically create queries on the data files...... The user version of query editor : Specific features This help page presents the specific features of the user version of query editor...... 9. Queries A query is used to request information from a database to view, insert, change or delete data.... Environment of the query editor Modifying the query content The queries are used to easily select the records coming from one or more files, matching one or more selection criteria, ...... Sub-query A sub-query is a query whose result is used by another query...... SQL commands available in an SQL query WINDEV allows you to easily run queries in SQL code...... Opening, closing and saving a query The query editor allows you to easily handle the queries.... Joins between the data files of a select query When several data files are used in a query, the query editor automatically searches for the links between these files described in the analysis...... Query creation mode: independent or embedded query The query editor proposes two methods for creating a query...... Example for creating a select query This help page explains how to create two select queries...... Welcome to Reports & Queries Reports & Queries is used to...... Description window of a combining query The description window of a combining query consists of several sections...... Query technical documentation The query editor automatically creates a technical documentation for each query...... SQL: Managing joins (INNER JOIN, OUTER JOIN) To select records coming from several data files, joins must be used in the SQL query...... HExecuteQuery (Function) Declares a query created in the query editor to the HFSQL engine and runs this query. <Source>.ExecuteQuery (Function) Declares a query created in the query editor to the HFSQL engine and runs this query. Creating a query Two methods can be used to create a query...... Creating a combining query A combining query (corresponding SQL statement: UNION) ...... <Source>.ListQueryParameter (Function) Returns the list of parameters for a query created in the query editor.