|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| Modifies the content of a row in the query result. |
|
|
|
|
|
|
|
| The query editor allows you to easily handle the queries.... |
|
|
|
|
|
|
|
| This help page explains how to create two linked cascading Table controls in a window or page.... |
|
|
|
|
|
|
|
| Goes to the next row (i.e next record) of the query result. |
|
|
|
|
|
|
|
| Retrieves the content of a Memo column from the query result, for the current row. |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support an optional Native SQL Server Connector (also called Native SQL Server Access)...... |
|
|
|
|
|
|
|
| Declares the end of the query execution and frees the memory resources allocated during the execution of the query. |
|
|
|
|
|
|
|
| Reports & Queries is used to...... |
|
|
|
|
|
|
|
| Retrieves the content of a Text Memo column found in the query result, for the current line. |
|
|
|
|
|
|
|
| Automatically associates each column of the query result with a control or with a variable of the application. |
|
|
|
|
|
|
|
| The Null keyword can be used according to different methods in WLanguage...... |
|
|
|
|
|
|
|
| The HFSQL Control Center allows you to fully manage HFSQL servers...... |
|
|
|
|
|
|
|
| Checks the existence of a query. |
|
|
|
|
|
|
|
| The CalculatedItemExpression property is used to:
Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or through programming.
Define the SQL expression returning the value of a calculated item (when describing the item through programming).... |
|
|
|
|
|
|
|
| The CalculatedDefaultValue property is used to:
Find out the SQL expression that defines the default value of an item. This item was defined in the data model editor or through programming.
Define the SQL expression that returns the default value of an item (item described through programming only).... |
|
|
|
|
|
|
|
| The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ...... |
|
|
|
|
|
|
|
| Returns the characteristics of all the columns (or items):
for a given table.
for a given query.... |
|
|
|
|
|
|
|
| Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Initializes a query and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Allows you to specify the version of the Native SQL Server Connector that will be used. |
|
|
|
|
|
|
|
| Modifies the rights granted to a user or to a group on a SQL view or on a materialized view. |
|
|
|
|
|
|
|
| Initializes the query linked to the report (for a query with parameters). |
|
|
|
|
|
|
|
| Initializes the query linked to the report (for a query with parameters). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|