|
|
|
|
|
|
|
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ... |
|
|
|
|
|
|
|
| Two methods can be used to create a query... |
|
|
|
|
|
|
|
| An Update query (SQL UPDATE statement) is used to modify the records in a database file... |
|
|
|
|
|
|
|
| To make the result of a query easier to read, the records can be sorted according to one or more items... |
|
|
|
|
|
|
|
| In the result of a select query, you have the ability to only display... |
|
|
|
|
|
|
|
| The description window of a select query includes several sections... |
|
|
|
|
|
|
|
| The query editor allows you to perform operations on the values of an item... |
|
|
|
|
|
|
|
| The query editor proposes two methods for creating a query... |
|
|
|
|
|
|
|
| A query created in the query editor can contain several types of items... |
|
|
|
|
|
|
|
| A select query (corresponding SQL statement... |
|
|
|
|
|
|
|
| The project comparator is used to compare two elements and to list the differences found... |
|
|
|
|
|
|
|
| This help page explains how to create two select queries... |
|
|
|
|
|
|
|
| When a "Date" item is found in the query, you have the ability to only select the records corresponding to a given period... |
|
|
|
|
|
|
|
| Finishes collecting information on executed queries. |
|
|
|
|
|
|
|
| When creating and developing the different elements of a project (window, query, report, project, ... |
|
|
|
|
|
|
|
| A delete query (corresponding SQL statement... |
|
|
|
|
|
|
|
| The query editor allows you to optimize the execution speed of one or more queries... |
|
|
|
|
|
|
|
| When creating a class in the code editor, the Constructor and Destructor methods are automatically created by default... |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| 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...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|