<Source>.NbRec (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Number of records processed by the INSERT/UPDATE/DELETE updates

See also

<Source>.NbRec (Function)

In french: <Source>.NbEnr

Not available with this kind of connection

Returns the number of records in a data file, query or HFSQL view: active records, crossed records, deleted records, etc.

Caution: <Source>.NbRec ignores the current filter.

Versions 15 and later

This function is now available for Android applications.

New in version 15

This function is now available for Android applications.

Versions 17 and later

This function is now available for iPhone/iPad applications.

New in version 17

This function is now available for iPhone/iPad applications.

Versions 18 and later

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

New in version 18

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

This function is now available in Android Widget mode.

This function is now available in Windows Store apps mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Example

// Active records in "Customer" data file
NbCustomerRec = Customer.NbRec()

Syntax

<Result> = <Source>.NbRec([<Options>])

<Result>: Integer

Number of records found,
-1 if an error occurred. HError returns more details about the problem.
Native XML Connector: the number of records depends on the use of <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.

<Source>: Type corresponding to the specified source

Name of data file, HFSQL view or query used.

<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.
This option is not available.
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 later
hBrowsableNonBlocking
New in version 24
hBrowsableNonBlocking
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

This parameter is ignored. The number of records calculated by <Source>.NbRec always corresponds to the total number of records found in the table, on 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, reinitialize a browse by using one of the following functions: <Source>.ReadFirst, <Source>.ReadLast, <Source>.First, <Source>.Last.
Access by JDBC
This parameter is ignored. The number of records calculated by <Source>.NbRec always corresponds to the total number of records found in the table, on 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, reinitialize a browse by using one of the following functions: <Source>.ReadFirst, <Source>.ReadLast, <Source>.First, <Source>.Last.

Remarks

Limitations

<Source>.NbRec does not return the number of records modified by an Update query (UPDATE).
<Source>.NbRec does not operate with the queries that use the hWithFilter constant.

xBase

<Source>.NbRec used with the hStateActive or hStateAll constant also returns the number of crossed records (or deleted records) (backward compatibility).

However, you can find out the number of crossed or deleted records by using <Source>.NbRec associated with the hStateDel or hStateCrossed constant.

Versions 18 and later

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.

New in version 18

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.

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

Component : wd260hf.dll