|
|
|
|
|
|
|
|
|
|
|
|
|
|
| When a "Date" item is found in the query, you have the ability to only select the records corresponding to a given period... |
|
|
|
|
|
|
|
| Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
|
| The query editor allows you to perform operations on the values of an item... |
|
|
|
|
|
|
|
| The selection conditions of records are applied to the items used in the queries... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| Comparing two windows (two pages, two reports, two classes, ... |
|
|
|
|
|
|
|
| Two methods can be used to create a query... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| When creating and developing the different elements of a project (window, query, report, project, ... |
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement... |
|
|
|
|
|
|
|
| The project comparator is used to compare two elements and to list the differences found... |
|
|
|
|
|
|
|
| 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 code history is used to... |
|
|
|
|
|
|
|
| A select query (corresponding SQL statement... |
|
|
|
|
|
|
|
| The query editor proposes two methods for creating a query... |
|
|
|
|
|
|
|
| Starts collecting information on executed queries. |
|
|
|
|
|
|
|
| Once a query is created, all the characteristics of this query can be modified at any time... |
|
|
|
|
|
|
|
| The query editor allows you to optimize the execution speed of one or more queries... |
|
|
|
|
|
|
|
| The description window of a select query includes several sections... |
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ... |
|
|
|
|
|
|
|
| This help page explains how to create two select queries... |
|
|
|
|
|
|
|
| In the result of a select query, you have the ability to only display... |
|
|
|
|
|
|
|
| The query editor allows you to run the test of query result... |
|
|
|
|
|
|
|
| An Update query (SQL UPDATE statement) is used to modify the records in a database file... |
|
|
|
|
|
|
|
| A delete query (corresponding SQL statement... |
|
|
|
|
|
|
|
| Dequeues an element from a queue. |
|
|
|
|
|
|
|
| WINDEV includes several Automatic Application Features (AAFs)...... |
|
|
|
|
|
|
|
| HFSQL proposes a quick search for character strings in the data...... |
|
|
|
|
|
|
|
| Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| Runs an SOQL query (Salesforce Object Query Language) on a Salesforce database. |
|
|
|
|
|
|
|
| The Selection property is used to get the characteristics of the selection (or cursor):
in a Word Processing control.
Remark: This selection is in the section being edited in the control (body, header or footer).
in a Spreadsheet control.
in an HTML Editor control.
in a Diagram Editor control.... |
|
|
|
|
|
|
|
| Let's see some operations specific to the description window of a select query...... |
|
|
|
|
|
|
|
| Declares the end of the query execution and frees the memory resources allocated during the execution of the 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 specific features of "Reports & Queries" (which means the user version of report editor) ...... |
|
|
|
|
|
|
|
| Does your application allow you to print several reports? The end user has the ability to write annotations from the report viewer...... |
|
|
|
|
|
|
|
| The cross-references in the code editor are used to identify...... |
|
|
|
|
|
|
|
| The selection of records performed by query is not necessarily displayed in a report, in a window, ...... |
|
|
|
|
|
|
|
| Several toolbars are displayed in the report editor...... |
|
|
|
|
|
|
|
| The Native AS/400 Connector simplifies access to AS/400 data from your WINDEV and WEBDEV applications...... |
|
|
|
|
|
|
|
| Regardless of the type of chart displayed in the Chart control, all its characteristics can be configured via its description window...... |
|
|
|
|
|
|
|
| Being able to perform a search in the editors significantly improves efficiency...... |
|
|
|
|
|
|
|
| This help page presents the actions that can be performed from the description window of a query.... |
|
|
|
|
|
|
|
| WINDEV, WINDEV Mobile and WEBDEV allow you to create custom interfaces with the window editor and the page editor...... |
|
|
|
|
|
|
|
| The following paragraphs present...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|