|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| Indicates whether the code is run during the test of a report or query in Reports & 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.... |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the HFSQL engine. |
|
|
|
|
|
|
|
| This help page explains how to create two linked cascading Table controls in a window or page.... |
|
|
|
|
|
|
|
| In some cases, it may be useful to run the same query multiple times while modifying one or more parameters...... |
|
|
|
|
|
|
|
| Hive is a software layer of Hadoop used to run queries...... |
|
|
|
|
|
|
|
| The "Find/Replace" feature is used to...... |
|
|
|
|
|
|
|
| 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...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|