|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 defined 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... |
|
|
|
|
|
|
|
| Allows you to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query. |
|
|
|
|
|
|
|
| Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view to a physical file (on disk). |
|
|
|
|
|
|
|
| Duplicates the record read in a data file: the record found in memory is added into the data file (query or view). |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| The FilterCondition property allows you to know the selection condition set by HFilter on a data file, HFSQL view or query. |
|
|
|
|
|
|
|
| Used to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query. |
|
|
|
|
|
|
|
| Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view to a physical file (on disk). |
|
|
|
|
|
|
|
| The ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) is completed.... |
|
|
|
|
|
|
|
| Displays a progress bar when:
receiving the response to an HTTP request.
sending an HTTP form (HTTPSendForm) or an HTTP query.... |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile include a Chart control (that can be used in the window editor, page editor and report editor) as well as several functions used to create and handle charts...... |
|
|
|
|
|
|
|
| A control is an indexed control if it contains several controls with the same name...... |
|
|
|
|
|
|
|
| Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc. |
|
|
|
|
|
|
|
| The FilterWithBounds property is used to determine if bounds have been specified for the filter implemented by HFilter on an HFSQL data file, view or query. |
|
|
|
|
|
|
|
| Determines:
whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
whether a view or a query was defined.... |
|
|
|
|
|
|
|
| Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc. |
|
|
|
|
|
|
|
| Determines:
whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
whether a view or a query was defined.... |
|
|
|
|
|
|
|
| The report editor allows you to create "Crosstab" reports...... |
|
|
|
|
|
|
|
| Edits an OLE object contained in an OLE control. |
|
|
|
|
|
|
|
| During a project test in the editor, breakpoints are used to automatically start the debugger from a given line...... |
|
|
|
|
|
|
|
| Returns:
the full path of the directory for the custom reports and queries. This directory corresponds to the directory of the reports and queries visible by the user who created them.
the full path of the directory for the shared reports and queries. This directory corresponds to the directory of the reports and queries visible by all the application users.... |
|
|
|
|
|
|
|
| Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password protected. |
|
|
|
|
|
|
|
| MySource is used to handle the current data source (file, view or query) associated with a report or with a table based on a data file... |
|
|
|
|
|
|
|
| Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password protected. |
|
|
|
|
|
|
|
| WINDEV allows you to handle an Image Editor control through programming...... |
|
|
|
|
|
|
|
| WINDEV Tutorial: WINDEV application: Managing data Lesson 3 - Multi-criteria search - 40 min |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|