|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 described 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... |
|
|
|
|
|
|
|
| Indicates whether the code is run during the test of a report or query in Reports & Queries. |
|
|
|
|
|
|
|
| The editor of Select queries is used to limit the number of records that will be displayed in the result of the query.... |
|
|
|
|
|
|
|
| The query editor allows you to optimize the execution speed of one or more queries...... |
|
|
|
|
|
|
|
| WINDEV Mobile allows you to easily create and print all types of reports with the report editor.... |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| WINDEV and WINDEV Mobile feature multiple methods to test applications...... |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile allow you to perform copies (or Drag and Drop) of controls between the products and their editors.... |
|
|
|
|
|
|
|
| The "Live Data" is used to view the content of the data files in the controls currently created in the different editors of the product used (window editor, page editor, report editor, ...... |
|
|
|
|
|
|
|
| Once the connection to the database is established, WDSQL allows you to create different types of SQL queries...... |
|
|
|
|
|
|
|
| A Data source variable is used to describe a temporary data source (query, view, alias, ...) |
|
|
|
|
|
|
|
| Creates a logical alias of a data file (or query) or cancels all existing aliases. |
|
|
|
|
|
|
|
| The SourceName property is used to:
Get the name of the report data source.
Change the report data source.... |
|
|
|
|
|
|
|
| WINDEV Tutorial - Reports and Queries Distribute Reports and Queries with your applications - 10 min |
|
|
|
|
|
|
|
| The "Context-sensitive code view" pane allows you to view and edit the code of the element (window, page, report, control, etc.... |
|
|
|
|
|
|
|
| This help page explains how to create two linked cascading Table controls in a window or page.... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| In some cases, it may be useful to run the same query multiple times while modifying one or more parameters...... |
|
|
|
|
|
|
|
| The "Find/Replace" feature is used to...... |
|
|
|
|
|
|
|
| Hive is a software layer of Hadoop used to run queries...... |
|
|
|
|
|
|
|
| In some cases, it may be useful to execute the same stored procedure multiple times by changing one or more parameters ...... |
|
|
|
|
|
|
|
| In some cases, it may be useful to execute the same stored procedure multiple times by changing one or more parameters...... |
|
|
|
|
|
|
|
| To specify the selection conditions in an SQL query, you can use...... |
|
|
|
|
|
|
|
| All editors of WINDEV, WEBDEV and WINDEV Mobile allow you to zoom in on the different elements displayed in the editor...... |
|
|
|
|
|
|
|
| The different options of the WINDEV, WEBDEV and WINDEV Mobile editors are presented via a ribbon...... |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile allow you to support up to 64 languages in the same project...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|