|
|
|
|
|
- Limitations
- xBase
- Number of records processed by the INSERT/UPDATE/DELETE updates
<Fuente>.NbRec (Función)
No disponible con este tipo de conexión
Returns the number of records in an HFSQL data file, query or view: active records, deleted records, etc. Attention The function <Fuente>.NbRec function ignores the current filter.
// Active records in "Customer" data file NbCustomerRec = Customer.NbRec()
Sintaxis
<Result> = <Source>.NbRec([<Options>])
<Result>: Entero - Number of records found,
- -1 if an error occurred. HError returns more details about the problem.
<Source>: Tipo de fuente especificada Name of data file, HFSQL view or query used. <Options>: Constante o combinación de constantes opcional 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. | hStateDel | Number of deleted records (does not include the crossed records). |
Observaciones Limitations - <Fuente>.NbRec does not return the number of records modified by an UPDATE query.
- <Fuente>.NbRec does not work with queries that use the hWithFilter constant.
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. Clasificación Lógica de negocio / UI: Lógica de negocio
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|