|
|
|
|
|
|
|
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement... |
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ... |
|
|
|
|
|
|
|
| When several data files are used in a query, the query editor automatically searches for the links between these files defined in the analysis... |
|
|
|
|
|
|
|
| The selection conditions of records are applied to the items used in the queries... |
|
|
|
|
|
|
|
| Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
|
| When a "Date" item is found in the query, you have the ability to only select the records corresponding to a given period... |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| A query created in the query editor can contain several types of items... |
|
|
|
|
|
|
|
| To make the result of a query easier to read, the records can be sorted according to one or more items... |
|
|
|
|
|
|
|
| This help page explains how to create two select queries... |
|
|
|
|
|
|
|
| The project comparator is used to compare two elements and to list the differences found... |
|
|
|
|
|
|
|
| The query editor proposes two methods for creating a query... |
|
|
|
|
|
|
|
| Once a query is created, all the characteristics of this query can be modified at any time... |
|
|
|
|
|
|
|
| Comparing two windows (two pages, two reports, two classes, ... |
|
|
|
|
|
|
|
| The query editor allows you to run the test of query result... |
|
|
|
|
|
|
|
| The query editor allows you to perform operations on the values of an item... |
|
|
|
|
|
|
|
| Defines and enables a "Contains" filter on a data file, view or query. |
|
|
|
|
|
|
|
| The xpathResult type is used it find out the result of the execution of an XPATH query. |
|
|
|
|
|
|
|
| Retrieves the content of a Memo column from the query result, for the current row. |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from the query result, for the current line. |
|
|
|
|
|
|
|
| Returns the characteristics of all the columns (or items):
for a given table.
for a given query.... |
|
|
|
|
|
|
|
| Retrieves the content of the specified column from 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. |
|
|
|
|
|
|
|
| Implementing input suggestions in an Edit control is very simple...... |
|
|
|
|
|
|
|
| During the life of an application, items live and die...... |
|
|
|
|
|
|
|
| A filter is used to define by programming a selection of records corresponding to one or more criteria...... |
|
|
|
|
|
|
|
| The navigation in the editors is simplified by the presence of a new dynamic navigation bar, enabled by [CTRL] + [TAB]...... |
|
|
|
|
|
|
|
| The document tabs allow you to navigate between the different elements opened in the different editors.... |
|
|
|
|
|
|
|
| The report editor allows you to create "Multicolumn" reports.... |
|
|
|
|
|
|
|
| The sfProcessWorkItemRequest type is used to describe a query for processing a task to submit to SFExecuteProcess... |
|
|
|
|
|
|
|
| Fills an array of classes or structures with the content of an HFSQL data file or query. |
|
|
|
|
|
|
|
| New features in WINDEV/WEBDEV/WINDEV Mobile 27 presented in the New Features brochure.... |
|
|
|
|
|
|
|
| Enables the filter that was previously created for the specified data file (view or query). |
|
|
|
|
|
|
|
| Creates a logical alias of a data file (or query) or cancels all existing aliases. |
|
|
|
|
|
|
|
| Initializes the different SQL variables with information relative to the last query run. |
|
|
|
|
|
|
|
| Enables the filter that was previously created for the specified data file (view or query). |
|
|
|
|
|
|
|
| Goes to the next row (i.e next record) of the query result. |
|
|
|
|
|
|
|
| The SQLCodeExecuted property gets the SQL code of a query after replacing the parameters with a value. |
|
|
|
|
|
|
|
| The controls can be copied from the page editor...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|