|
|
|
|
|
|
|
|
|
|
|
|
|
|
| When creating a class in the code editor, the Constructor and Destructor methods are automatically created by default... |
|
|
|
|
|
|
|
| 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 selection conditions of records are applied to the items used in the queries... |
|
|
|
|
|
|
|
| The query editor allows you to run the test of query result... |
|
|
|
|
|
|
|
| Once a query is created, all the characteristics of this query can be modified at any time... |
|
|
|
|
|
|
|
| The query editor proposes two methods for creating a query... |
|
|
|
|
|
|
|
| When several tables are used in a query, the query editor automatically searches for the links between these tables described in the database schema... |
|
|
|
|
|
|
|
| Comparing two windows (two pages, two reports, two classes, ... |
|
|
|
|
|
|
|
| An insert query (corresponding SQL statement... |
|
|
|
|
|
|
|
| A query created in the query editor can contain several types of items... |
|
|
|
|
|
|
|
| A combining query (corresponding SQL statement: UNION) ... |
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| A select query (corresponding SQL statement... |
|
|
|
|
|
|
|
| A query (typed in SQL code) can operate on different databases...... |
|
|
|
|
|
|
|
| The different editors enable you to directly view the code of an element by pressing the F2 key...... |
|
|
|
|
|
|
|
| The Cursor property is used to get and change the position of the mouse cursor in one of the following controls:
Edit control.
Editable Combo Box.
"Edit control" table column and "Editable Combo Box" table column.
Word Processing control.
HTML Editor control.... |
|
|
|
|
|
|
|
| The "Find - Replace" pane is used to...... |
|
|
|
|
|
|
|
| WINDEV, WINDEV Mobile and WEBDEV propose several dockable panes...... |
|
|
|
|
|
|
|
| Deletes all records from a data file, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Deletes all records from a data file, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Defines and enables a "Start with" filter on a file, view or query. |
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a file, view or query. |
|
|
|
|
|
|
|
| Defines and enables a filter on a data file, view or query. |
|
|
|
|
|
|
|
| Defines and enables a "Start with" filter on a file, view or query. |
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a file, view or query. |
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
| Deletes a query (used by stored procedures) from an HFSQL server. |
|
|
|
|
|
|
|
| Executes an XPATH query:
in an XML document.
in an xmlDocument variable.... |
|
|
|
|
|
|
|
| Deletes a query (used by stored procedures) from an HFSQL server. |
|
|
|
|
|
|
|
| Creates a Table control from the items of a data file (view or query). |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile allow you to use the OpenOffice spelling checker in your interfaces... |
|
|
|
|
|
|
|
| The development in "3-tier" architecture is now simplified...... |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)...... |
|
|
|
|
|
|
|
| Defines and enables a "Contains" filter on a data file, view or query. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|