|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| List of SQL functions used to access the external databases |
|
|
|
|
|
|
|
| An SQL query can operate on different databases... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| The query editor allows you to create a query by typing SQL code... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| The "Analysis" pane lists...... |
|
|
|
|
|
|
|
| This help page presents the actions that can be performed from the description window of a query.... |
|
|
|
|
|
|
|
| The queries with parameters allow the user to easily select records according to his own requirements...... |
|
|
|
|
|
|
|
| The selection of records performed by query is not necessarily displayed in a report, in a window, ...... |
|
|
|
|
|
|
|
| Retrieves the characteristics of a queue: types of elements and number of elements. |
|
|
|
|
|
|
|
| Retrieves the characteristics of a queue: types of elements and number of elements. |
|
|
|
|
|
|
|
| Transfers the result of a query to a Table control populated programmatically (a List Box or Combo Box control), with the possibility of Partial Fetch (the result is retrieved by blocks of rows). |
|
|
|
|
|
|
|
| Native SQL Server Connector (also known as Native SQL Server Access) license agreement... |
|
|
|
|
|
|
|
| The controls from a window can be linked to a data file or existing query, ...... |
|
|
|
|
|
|
|
| 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).... |
|
|
|
|
|
|
|
| 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).... |
|
|
|
|
|
|
|
| The table below presents the main extensions of files created and supported by WINDEV, WEBDEV and WINDEV Mobile...... |
|
|
|
|
|
|
|
| List of functions for managing the queues, the stacks and the lists... |
|
|
|
|
|
|
|
| A Queue variable is a structured type that groups a set of elements of the same type. |
|
|
|
|
|
|
|
| Generates a page break: the corresponding code is sent to the printer queue. |
|
|
|
|
|
|
|
| This type of TreeView Table control is linked to a data file or query...... |
|
|
|
|
|
|
|
| The NbPendingThread property is used to get the number of pending threads in a queue or in a stack. |
|
|
|
|
|
|
|
| Initializes the query linked to the report. |
|
|
|
|
|
|
|
| Initializes the query linked to the report. |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| The AdditionCompleted property determines if an element was added to a queue, list or stack, or if the operation is in progress. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|