|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| The ORDER BY clause is used to sort the records selected by an SQL query...... |
|
|
|
|
|
|
|
| Environment of the report editor... |
|
|
|
|
|
|
|
| The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows...... |
|
|
|
|
|
|
|
| The main elements of the project editor are as follows: |
|
|
|
|
|
|
|
| The main elements of window editor are as follows: |
|
|
|
|
|
|
|
| The Type property is used to get:
the type of element (data file or item) defined programmatically or in the data model editor, view or query.
the type of object.
the type of data held in a Variant.... |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| The "SQL query" type is used to write an SQL query in the WLanguage code. |
|
|
|
|
|
|
|
| Regardless of the query type (Select, Insert, Delete, Update) and regardless of its creation mode (with the wizard or by SQL directly), you have the ability to use parameters. The name of the parameter is specified when creating the query.... |
|
|
|
|
|
|
|
| The controls from a window can be linked to a data file or existing query, ...... |
|
|
|
|
|
|
|
| The different editors of WINDEV, WEBDEV and WINDEV Mobile allow you to align the elements via a snap-on grid...... |
|
|
|
|
|
|
|
| The description window of a query (insert, update or delete) or the description window of a query in SQL code is used to...... |
|
|
|
|
|
|
|
| Queries are used to easily select records in one or more data files...... |
|
|
|
|
|
|
|
| The RecordSize property is used to get the size (in bytes) of a record in:
a file described in the data model editor,
a file described through programming,
an HFSQL view,
a query.... |
|
|
|
|
|
|
|
| To use an SQLite database with Native Connector (also called Native Access), the structure of SQLite tables must be imported into the data model editor.... |
|
|
|
|
|
|
|
| The NbMemoItem property is used to get the total number of memo items in a record of:
a file described in the data model editor,
a file described through programming,
an HFSQL view,
a query.... |
|
|
|
|
|
|
|
| WLanguage includes the "WL" keyword...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|