• Number of records found,
• -1 if an error occurred. HError returns more details about the problem.

Native XML connector Record: the number of records depends on the use of functions <Source>.ActivateAutoFilter/<Source>.DeactivateAutoFilter:

• If the filtering is enabled, only the records belonging to the current parent are taken into account.
• If the filter is not active, the records found in the XML file are taken into account.

The filtering is enabled by default.

Name of data file, HFSQL view or query used.

Configures the type of record to count.

hBrowsableNonBlocking	Number of records in the view or query that can currently be read (no record locking). This constant is available for the views and queries in HFSQL Classic or Client/Server. This constant has no effect for the data files and for the Native Connectors
hNonBlocking	Number of records retrieved in the view or query without waiting for the view or query to be entirely filled. To knwo if the execution of the view or query is completed, use the ExecutionCompleted property. This constant is available for the views and queries in HFSQL Classic or Client/Server. This constant has no effect for the data files and for the Native Connectors
hStateActive (default value)	Number of active records (not crossed or deleted).
hStateAll	Total number of records in the data file (hStateActive + hStateCrossed + hStateDel).
hStateCrossed	Number of crossed records. This option is not available.
hStateDel	Number of deleted records (does not include the crossed records).

This parameter is ignored. The number of records calculated by <Fuente>.NbRec always corresponds to the total number of records in the table, in the database.

This number can differ from the number of displayed records if records have been added or deleted by another user. To view these new records, reset a route using one of the following functions: <Source>.ReadFirst, <Source>.ReadLast, <Source>.First, <Source>.Last.

Access through JDBC
This parameter is ignored. The number of records calculated by <Fuente>.NbRec always corresponds to the total number of records in the table, in the database.
This number can differ from the number of displayed records if records have been added or deleted by another user. To view these new records, reset a route using one of the following functions: <Source>.ReadFirst, <Source>.ReadLast, <Source>.First, <Source>.Last.