|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| 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 HFSQL Control Center allows you to fully manage HFSQL Client/Server data files...... |
|
|
|
|
|
|
|
| Here are the new features that you will discover in this version...... |
|
|
|
|
|
|
|
| Connects the current application to a database that will be queried by SQL through a Webservice proxy (SOAP). |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| The remote HFSQL administrator proposes a full management of the HFSQL Client/Server databases...... |
|
|
|
|
|
|
|
| Connects the current application to a database that must be interrogated via SQL. |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage HFSQL Classic tables...... |
|
|
|
|
|
|
|
| A Data source variable is used to describe a temporary data source (query, view, alias, ...) |
|
|
|
|
|
|
|
| When creating a report, the test of this report can be run from the report editor...... |
|
|
|
|
|
|
|
| To use an SQL Server database with Native Connector, the structure of SQL Server tables must be imported into the data model analysis...... |
|
|
|
|
|
|
|
| Positions on the previous row of the query result. |
|
|
|
|
|
|
|
| Positions on the next row of the query result. |
|
|
|
|
|
|
|
| A Table, List Box, or Combo Box control can be used to display the content of a table or query...... |
|
|
|
|
|
|
|
| To use a DB2 database with Native Connector, the structure of DB2 tables must be imported into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| To use an Informix database with the Native Connector, import the structure of Informix tables into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| Sets the position on the last row of the query result. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|