|
|
|
|
|
|
|
|
|
|
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 gets 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:- get and set the top value of a report based on a data file.
- get the maximum value of the current filter.
- get the maximum value of a data series in a chart.
- get and set 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:- get and set the bottom value of a report based on a data file.
- get the minimum value of the current filter.
- get the minimum value of a data series in a chart.
- get and set 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 programmatically,
- 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 programmatically,
- 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 programmatically,
- 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 programmatically,
- 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 (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.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|