// Active records in "Customer" data file
NbCustomerRec = HNbRec(Customer)
Syntax
<Result> = HNbRec([<Data file> [, <Options>]])
<Result>: Integer
- Number of records found,
- -1 if an error occurred. HError returns more details about the problem.
<Data file>: Optional character string (with or without quotes)
Name of data file, HFSQL view or query used. If this parameter is not specified, HNbRec will use the last data file used by the last HFSQL management function (function starting with "H").
<Options>: Optional constant (or combination of constants)
Configures the type of record to count. | |
hStateActive (default value) | Number of active records (not crossed or deleted). |
hStateCrossed | Number of crossed records. |
hStateDel | Number of deleted records (does not include the crossed records). |
hStateAll | Total number of records in the data file (hStateActive + hStateCrossed + hStateDel). |
Versions 24 and laterhBrowsableNonBlocking New in version 24hBrowsableNonBlocking hBrowsableNonBlocking | Number of records in the view or query that can currently be browsed (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 find out whether the execution of the view or query is completed, use ..ExecutionCompleted. 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 |
Remarks
Limitations
- HNbRec does not return the number of records modified by an Update query (UPDATE).
- HNbRec does not operate with the queries that use the hWithFilter constant.
Versions 18 and laterNumber of records processed by the INSERT/UPDATE/DELETE updates
When running an INSERT/UPDATE/DELETE query on HFSQL data files, the number of added, modified or deleted records is returned by the
H.NbRecModificationQuery variable.
New in version 18Number of records processed by the INSERT/UPDATE/DELETE updates
When running an INSERT/UPDATE/DELETE query on HFSQL data files, the number of added, modified or deleted records is returned by the
H.NbRecModificationQuery variable.
Number of records processed by the INSERT/UPDATE/DELETE updates
When running an INSERT/UPDATE/DELETE query on HFSQL data files, the number of added, modified or deleted records is returned by the
H.NbRecModificationQuery variable.
Business / UI classification : Business Logic