|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Restores the context of a previously saved file (HSavePosition): current record, filter, pointers. |
|
|
|
|
|
|
|
| Duplicates the record read in a data file: the record found in memory is added into the data file (query or view). |
|
|
|
|
|
|
|
| The Password property can be used:
on the edit controls (or on the text table columns) to find out whether the control is a "Password" control or to modify the "Password" type of the control.
on the connections (HFSQL Client/Server, OLE DB, etc.) to define the password of the user who uses the connection.... |
|
|
|
|
|
|
|
| The CalculatedItemExpression property is used to:
Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or through programming.
Define the SQL expression returning the value of a calculated item (when describing the item through programming).... |
|
|
|
|
|
|
|
| The mathematical SQL functions that can be used on the queries written in SQL code are as follows...... |
|
|
|
|
|
|
|
| If a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction. |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile include multiple methods to filter the records displayed in a Table control based on a data file...... |
|
|
|
|
|
|
|
| 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). |
|
|
|
|
|
|
|
| Defines and enables a filter used to find the exact value of a string item. |
|
|
|
|
|
|
|
| Adds:
the record found in memory into the data file (query or view).
the record found in a Record variable into the data file (query or view).... |
|
|
|
|
|
|
|
| Returns the number of records in a file, query or HFSQL view: active records, crossed records, deleted records, etc. |
|
|
|
|
|
|
|
| Enables or disables the management of duplicates on a unique key. |
|
|
|
|
|
|
|
| Returns the list of triggers applied to one or more HFSQL data files. |
|
|
|
|
|
|
|
| Defines and enables an "Included between" filter on a file, view or query. |
|
|
|
|
|
|
|
| Used to find out the state of a record. |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Defines and enables a "Start with" filter on a file, view or query. |
|
|
|
|
|
|
|
| Crosses a record in a data file. |
|
|
|
|
|
|
|
| WINDEV, WEBDEV and WINDEV Mobile include a module for assisted management of HFSQL errors...... |
|
|
|
|
|
|
|
| Using WDConver in command line mode consists in running a conversion description created and saved with WDConver ("...... |
|
|
|
|
|
|
|
| The following SQL functions can be used on the queries written in SQL code (classified by theme)...... |
|
|
|
|
|
|
|
| Checks the existence of an external file. |
|
|
|
|
|
|
|
| Finds documents in a MongoDB collection. |
|
|
|
|
|
|
|
| Usage example of the InAndroidMode function |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|