|
|
|
|
|
|
|
|
|
|
|
|
|
|
| This help page explains how to create and run an SQL query through programming. |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| A report based on an SQL query with data accessed via a connection can print records from a database accessible via a specific ODBC driver or via a Native Connector... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| List of SQL functions used to access the external databases |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| An SQL query can operate on different databases... |
|
|
|
|
|
|
|
| Returns a list of keys to add to tables to improve query performance. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| A query is used to interrogate a database in order to view, insert, modify or delete data...... |
|
|
|
|
|
|
|
| Two methods can be used to pass parameters to a query with parameters used in a window or in a control (List Box, Combo Box or Table control for example)...... |
|
|
|
|
|
|
|
| Indicates whether the code is run during the test of a report or query in Reports & Queries. |
|
|
|
|
|
|
|
| The query editor allows you to run the test of query result...... |
|
|
|
|
|
|
|
| This help page presents the specific features of the user version of query editor...... |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| Positions on the specified result row of the query. |
|
|
|
|
|
|
|
| The query editor proposes two methods for creating a query...... |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage HFSQL Client/Server databases...... |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| Modifies the content of a row in the query result. |
|
|
|
|
|
|
|
| A query is used to interrogate a database in order to view, insert, modify or delete data...... |
|
|
|
|
|
|
|
| This help page explains how to create two linked cascading Table controls in a window or page.... |
|
|
|
|
|
|
|
| The query editor allows you to easily handle the queries.... |
|
|
|
|
|
|
|
| Goes to the next row (i.e next record) of the query result. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|