|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Populates a Table control programmatically with the records from a data file, HFSQL view or query (query created in the query editor or with HExecuteSQLQuery). |
|
|
|
|
|
|
|
| Returns the list of parameters for a query created in the query editor. |
|
|
|
|
|
|
|
| Returns the list of parameters for a query created in the query editor. |
|
|
|
|
|
|
|
| Adds an element to the queue. |
|
|
|
|
|
|
|
| Adds an element to the queue. |
|
|
|
|
|
|
|
| Dequeues an element from a queue. |
|
|
|
|
|
|
|
| List of SQL functions: Special case... |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the database schema to an HFSQL server. |
|
|
|
|
|
|
|
| Removes an element from the queue. |
|
|
|
|
|
|
|
| Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database. |
|
|
|
|
|
|
|
| Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database. |
|
|
|
|
|
|
|
| For compatibility with the earlier versions of the Native SQL Server Connector (also called Native SQL Server Access), the connection can still be configured in WDSQSINS (supplied with the Native SQL Server Connector)...... |
|
|
|
|
|
|
|
| Let's see some operations specific to the description window of a select query...... |
|
|
|
|
|
|
|
| Continues to run a SOQL query (Salesforce Object Query Language) on the records of a Salesforce database. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|