|
|
|
|
|
|
|
|
|
|
|
|
|
|
| The query editor is used to automatically create queries on the data files...... |
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ...... |
|
|
|
|
|
|
|
| Regardless of the query type (Select, Insert, Delete, Update) and regardless of its creation mode (with the wizard or by SQL directly), you have the ability to use parameters. The name of the parameter is specified when creating the query.... |
|
|
|
|
|
|
|
| This help page explains how to create an SQL query to filter records.... |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| A query is used to request information from a database to view, insert, change or delete data.... |
|
|
|
|
|
|
|
| A sub-query is a query whose result is used by another query...... |
|
|
|
|
|
|
|
| Returns the list of available remote accesses. |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query...... |
|
|
|
|
|
|
|
| The query editor allows you to run the test of query result...... |
|
|
|
|
|
|
|
| This help page explains how to create a query with a calculation formula with the query editor.... |
|
|
|
|
|
|
|
| This help page explains how to create a sort query with the query editor.... |
|
|
|
|
|
|
|
| A query is used to interrogate a database in order to view, insert, modify or delete data...... |
|
|
|
|
|
|
|
| Configures the management of accesses to the ActiveX objects and to the Automation objects. |
|
|
|
|
|
|
|
| The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code...... |
|
|
|
|
|
|
|
| Indicates whether the code is run during the test of a report or query in Reports & Queries. |
|
|
|
|
|
|
|
| In SQL language, an external join is used to exclude or include file records with or without correspondences in the linked files...... |
|
|
|
|
|
|
|
| The Table control is used to simplify the display and the input of information stored in memory or coming from a data file, a view or a query...... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Used to lock:
The entire data table, in read and write mode. Its data cannot be accessed by other computers.
The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example.... |
|
|
|
|
|
|
|
| Two methods can be used to create a query...... |
|
|
|
|
|
|
|
| To select records coming from several data files, joins must be used in the SQL query...... |
|
|
|
|
|
|
|
| The Native Oracle Connector is used to:
specify the input values during the call to a stored procedure.
retrieve the output values after a call to a stored procedure.... |
|
|
|
|
|
|
|
| Queries are used to easily select records in one or more data files...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|