|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Adds:
the record found in memory into the data file (query or view).
the record found in a Record variable into the data file (query or view).... |
|
|
|
|
|
|
|
| Add:
the record found in memory into the data file (query or view).
the record found in a Record variable into the data file (query or view).... |
|
|
|
|
|
|
|
| Opens a system window to select a resource from:
from the device file system,
from the Cloud (Google Drive, Microsoft OneDrive, etc.)
or from one of the content managers installed on the device.... |
|
|
|
|
|
|
|
| Controls in a window can be linked to a data file or existing query.... |
|
|
|
|
|
|
|
| List of functions for managing the queues, the stacks and the lists... |
|
|
|
|
|
|
|
| Generates a page break: the corresponding code is sent to the printer queue. |
|
|
|
|
|
|
|
| A Queue variable is a structured type that groups a set of elements of the same type. |
|
|
|
|
|
|
|
| This type of TreeView Table control is linked to a data file or query...... |
|
|
|
|
|
|
|
| The "Database schema" pane shows...... |
|
|
|
|
|
|
|
| Initializes the query linked to the report. |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Initializes the query linked to the report. |
|
|
|
|
|
|
|
| Sends a query to a DNS server. |
|
|
|
|
|
|
|
| The NbPendingThread property is used to get the number of pending threads in a queue or in a stack. |
|
|
|
|
|
|
|
| The Native SQL Server 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.... |
|
|
|
|
|
|
|
| ODBCUserName is used to:
Identify the username used to connect to a database via an ODBC driver or a Native Connector.
Specify the username used to connect to a database via an ODBC driver or a Native Connector.... |
|
|
|
|
|
|
|
| The ODBCPassword property is used to:
Identify the password used to connect to a database via an ODBC driver or a Native Connector.
Specify the password used to connect to a database via an ODBC driver or a Native Connector.... |
|
|
|
|
|
|
|
| The AdditionCompleted property determines if an element was added to a queue, list or stack, or if the operation is in progress. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|