|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| List of SQL functions used to access the external databases |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| An SQL query can operate on different databases... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| Queries are used to easily select records in one or more data files...... |
|
|
|
|
|
|
|
| To use a PostgreSQL database with Native Connector (also called Native Access), the structure of PostgreSQL tables must be imported into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| Positions on the first row of the query result. |
|
|
|
|
|
|
|
| To use an Oracle database with the Native Connector, the structure of ORACLE tables must be imported into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| To use a Progress database with the Native Connector, you must ...... |
|
|
|
|
|
|
|
| ODBCDatabaseName is used to:
Find out the name of the database used when printing a report based on a "query performed on a connection".
Specify the name of the database used when printing a report based on a "query performed on a connection".... |
|
|
|
|
|
|
|
| The ODBCConnectionName property is used to:
Identify the name of the ODBC connection used when printing a report based on a "query performed on a connection".
Specify the name of the ODBC connection used when printing a report based on a "query performed on a connection".... |
|
|
|
|
|
|
|
| WEBDEV allows you to create a PHP site that handles data files...... |
|
|
|
|
|
|
|
| Prints a report created with the report editor. |
|
|
|
|
|
|
|
| This help page explains how to create two select queries...... |
|
|
|
|
|
|
|
| Queries can be based on items from another query...... |
|
|
|
|
|
|
|
| "Password" items are used to securely store passwords by using a salt and a hash algorithm...... |
|
|
|
|
|
|
|
| The queries are used to easily select the records coming from one or more files, matching one or more selection criteria, ...... |
|
|
|
|
|
|
|
| A query is used to request information from a database to view, insert, change or delete data.... |
|
|
|
|
|
|
|
| The query editor allows you to run the test of query result...... |
|
|
|
|
|
|
|
| A query is used to interrogate a database in order to view, insert, modify or delete data...... |
|
|
|
|
|
|
|
| Indicates whether the code is run during the test of a report or query in Reports & Queries. |
|
|
|
|
|
|
|
| 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)...... |
|
|
|
|
|
|
|
| This help page presents the specific features of the user version of query editor...... |
|
|
|
|
|
|
|
| The query editor proposes two methods for creating a query...... |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| A query is used to interrogate a database in order to view, insert, modify or delete data...... |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage HFSQL Client/Server databases...... |
|
|
|
|
|
|
|
| Positions on the specified result row of the query. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|