These properties can be used on the HFSQL queries or views.
| |
| DescribedName | ..DescribedName is used to manage the logical name of HFSQL files. |
| ExecutionCompleted | ..ExecutionCompleted is used to find out whether the execution of a query or view (in HFSQL Classic or Client/Server format) is completed. |
| FilterCondition | ..FilterCondition is used to find out the selection condition implemented by HFilter on a data file, a HFSQL view or a query. |
| FilteredItem | ..FilteredItem is used to find out the item on which a filter was implemented by HFilter. |
| FilterWithBounds | ..FilterWithBounds is used to find out whether bounds have been specified for the filter implemented byHFilter on a HFSQL data file, view or query. |
| MaxAutoID | ..MaxAutoID is used to find out the maximum automatic identifier on a replicated file. |
| MaxValue | ..MaxValue is used to:- find out and modify the upper bound of a report based on a data file.
- find out the upper bound defined for the current filter.
- find out the maximum value of a chart series.
- find out and modify the maximum value for some types of controls.
|
| MinAutoID | ..MinAutoID is used to find out the minimum automatic identifier on a replicated file. |
| MinValue | ..MinValue is used to:- find out and modify the lower bound of a report based on a data file.
- find out the lower bound defined for the current filter.
- find out the minimum value of a chart series.
- find out and modify the minimum value for some types of controls.
|
 Versions 09 and laterName New in version 09Name | ..Name is used to find out:- the name of the font associated with a Font variable.
- the name of a control, report or report block.
- the name of a control, group of controls or window.
- the name of a control, group of controls or page.
|
| NbItem | ..NbItem is used to find out the total number of items (including composite keys) in a record found in:- a file described in the data model editor,
- a file described by programming,
- a HFSQL view,
- a query.
|
| NbKeyItem | ..NbKeyItem returns the total number of key items (including composite keys) found in a record of:- a file described in the data model editor,
- a file described by programming,
- a HFSQL view,
- a query.
|
| NbMemoItem | ..NbMemoItem returns the total number of memo items found in a record of:- a file described in the data model editor,
- a file described by programming,
- a HFSQL view,
- a query.
|
| RecordSize | ..RecordSize is used to find out and modify the size (in bytes) of a record found in:- a file described in the data model editor,
- a file described by programming,
- a HFSQL view,
- a query.
|
| SQLCode | ..SQLCode is used to find out the SQL code of a query created with the query editor (".WDR" file). |
Versions 09 and laterType New in version 09Type Type | ..Type is used to find out:- the type of element described by programming (file or item description) or not (file or item defined in the data model editor, view or query).
- the type of object.
- the type of value stored in a variant.
|