|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Two types of browse can be used to browse the result of a query run by SQLExec...... |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
|
|
|
|
|
|
|
| Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| An HFSQL view corresponds to a "memory image" of an HFSQL data file...... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| The following paragraphs present the main aspects and specific features of the Native SQL Server Connector...... |
|
|
|
|
|
|
|
| Removes an element from the queue. |
|
|
|
|
|
|
|
| Adds an element to the queue. |
|
|
|
|
|
|
|
| Adds an element to the queue. |
|
|
|
|
|
|
|
| Dequeues an element from a queue. |
|
|
|
|
|
|
|
| The Table control is used to simplify the display and the input of information stored in memory or coming from a data file, a view or a query...... |
|
|
|
|
|
|
|
| List of SQL functions: Special case... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Continues to run a SOQL query (Salesforce Object Query Language) on the records of a Salesforce database. |
|
|
|
|
|
|
|
| This help page presents the actions that can be performed from the description window of a query.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|