|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 methods can be used to create a query...... |
|
|
|
|
|
|
|
| The editor of Select queries is used to limit the number of records that will be displayed in the result of the query.... |
|
|
|
|
|
|
|
| The procedures and the methods of classes can have several syntaxes.... |
|
|
|
|
|
|
|
| WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed....... |
|
|
|
|
|
|
|
| SQL allows performing set operations on groups of files...... |
|
|
|
|
|
|
|
| The mathematical SQL functions that can be used on the queries written in SQL code are as follows...... |
|
|
|
|
|
|
|
| A sub-query is a query whose result is used by another query...... |
|
|
|
|
|
|
|
| The description window of a query (insert, update or delete) or the description window of a query in SQL code is used to...... |
|
|
|
|
|
|
|
| Starting with version 21, you can manage transactions in SQL code...... |
|
|
|
|
|
|
|
| The query editor automatically creates a technical documentation for each query...... |
|
|
|
|
|
|
|
| You have the ability to pass parameters to a procedure.... |
|
|
|
|
|
|
|
| The description window of a select query includes several sections...... |
|
|
|
|
|
|
|
| The selection conditions of records are applied to the items used in the queries...... |
|
|
|
|
|
|
|
| To simplify the maintenance or the use of existing code by other developers, WINDEV proposes an automatic documentation for the procedures (or class methods)...... |
|
|
|
|
|
|
|
| The description window of a combining query consists of several sections...... |
|
|
|
|
|
|
|
| A procedure is used to associate an identifier with a statement block...... |
|
|
|
|
|
|
|
| Syntax for calling a local or global procedure. |
|
|
|
|
|
|
|
| A query created in the query editor can contain several types of items...... |
|
|
|
|
|
|
|
| A color (text color) can be assigned to the procedures so that they can be easily classified and identified...... |
|
|
|
|
|
|
|
| A global procedure can be used in all the processes or events of the project.... |
|
|
|
|
|
|
|
| The query editor allows you to perform operations on the values of an item...... |
|
|
|
|
|
|
|
| Declares a query created in the query editor to the HFSQL engine and runs this query. |
|
|
|
|
|
|
|
| The global procedures are grouped in set of procedures...... |
|
|
|
|
|
|
|
| Two types of procedures are available...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|