|
|
|
|
HFSQL properties associated with the queries and views
Available only with these kinds of connection
These properties can be used on the HFSQL queries or views. | | DescribedName | The DescribedName property is used to handle the logical name of HFSQL data files (ignoring possible changes made by HAlias). | ExecutionCompleted | The ExecutionCompleted property is used to determine whether the execution of a query or view (HFSQL Classic or Client/Server) is completed. | FilterCondition | The FilterCondition property allows you to know the selection condition set by HFilter on a data file, HFSQL view or query. | FilteredItem | The FilteredItem property is used to identify the item that has a filter implemented by HFilter. | FilterWithBounds | 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. | MaxAutoID | The MaxAutoID property is used to get the maximum automatic identifier of a replicated data file. | MaxValue | The MaxValue property 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 | The MinAutoID property is used to get the minimum automatic identifier of a replicated data file. | MinValue | The MinValue property 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.
| Name | The Name property is used to get:- 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 | 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 through programming,
- an HFSQL view,
- a query.
| NbKeyItem | 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.
| NbMemoItem | 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.
| RecordSize | 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.
| SQLCode | The SQLCode code property is used to get the SQL code of a query created with the query editor (".WDR" file). | Type | The Type property is used to get:- the type of element described through 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.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|