|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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... |
|
|
|
|
|
|
|
| The NbItem property is used to get the total number of items (including composite keys) in a record of:
a file described in the data model editor,
a file described programmatically,
an HFSQL view,
a query.... |
|
|
|
|
|
|
|
| Two methods can be used to pass parameters to a query with parameters used in a window or in a control (List Box, Combo Box or Table control for example)...... |
|
|
|
|
|
|
|
| A Table, List Box or Combo Box control can be used to display the content of a data file or query...... |
|
|
|
|
|
|
|
| The NbKeyItem property is used to get the total number of key items (including composite keys) in a record of:
a file described in the data model editor,
a file described through programming,
an HFSQL view,
a query.... |
|
|
|
|
|
|
|
| A Table control can be used to display the content of a data file or query...... |
|
|
|
|
|
|
|
| The Alias type is used to declare and handle a logical alias for a data file or query. |
|
|
|
|
|
|
|
| The report editor allows you to create "Crosstab" reports...... |
|
|
|
|
|
|
|
| To use an Informix database with the Native Connector, import the structure of Informix tables into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| To use a Sybase database with Native Connector, the structure of Sybase tables must be imported into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| Initializes the query linked to the report. |
|
|
|
|
|
|
|
| To use an SQL Server database with Native Connector, the structure of SQL Server tables must be imported into the data model analysis...... |
|
|
|
|
|
|
|
| To use a DB2 database with Native Connector, the structure of DB2 tables must be imported into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| This help page presents the different data sources available for a control.... |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile allow you to manage the NULL value in the items of HFSQL data files and for all the other types of accesses (Native, OLE DB, ...... |
|
|
|
|
|
|
|
| Returns the number of the current record in a Looper control based on a data file. |
|
|
|
|
|
|
|
| To use a MariaDB database with Native Connector, the structure of MariaDB tables must be imported into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| To use a MySQL database with the Native Connector (or Native Access), import the structure of MySQL tables into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| Names and runs an SQL query. |
|
|
|
|
|
|
|
| To use a PostgreSQL database with Native Connector (also called Native Access), the structure of PostgreSQL tables must be imported into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| To use a Progress database with the Native Connector, you must ...... |
|
|
|
|
|
|
|
| Returns the number of the current record in a Table control based on a data file. |
|
|
|
|
|
|
|
| To use an Oracle database with the Native Connector, the structure of ORACLE tables must be imported into the WINDEV or WEBDEV analysis...... |
|
|
|
|
|
|
|
| An SQL view is a virtual data source defined by an SQL query...... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|