PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Limitations
  • xBase
  • Number of records processed by the INSERT/UPDATE/DELETE updates
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
HNbRec (Function)
In French: HNbEnr
ODBCNot available with this kind of connection
Returns the number of records in a data file, a query or a HFSQL view: active records, crossed records, deleted records, etc.
Caution: HNbRec ignores the current filter.
Versions 15 and later
Android This function is now available for the Android applications.
New in version 15
Android This function is now available for the Android applications.
Android This function is now available for the Android applications.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
// Active records found in "Customer" file
NbCustomerRec = HNbRec(Customer)
Syntax
<Result> = HNbRec([<File Name> [, <Options>]])
<Result>: Integer
  • Number of records found,
  • -1 if an error occurred. HError returns more details about the problem.
Native Accesses Native XML access: the number of records depends on the use of HActivateAutoFilter/HDeactivateAutoFilter:
  • 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.
<File Name>: Optional character string (with or without quotes)
Name of data file, HFSQL view or query used. If this parameter is not specified, HNbRec handles the last data file used by the last function for HFSQL management (starting with the letter 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).
hStateCrossedNumber of crossed records.
Hyper File 5.5 This option is not available.
hStateDelNumber of deleted records (does not include the crossed records).
hStateAllTotal number of records in the data file (hStateActive + hStateCrossed + hStateDel).
hNotLockingNumber 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 accesses.
PHPOLE DBNative Accesses This parameter is ignored. The number of records calculated by HNbRec 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: HReadFirst, HReadLast, HFirst, HLast.
Java Access by JDBC
This parameter is ignored. The number of records calculated by HNbRec 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: HReadFirst, HReadLast, HFirst, HLast.
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.
WINDEVWEBDEV - Server codeExternal languageNative Accesses

xBase

HNbRec 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 HNbRec 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.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Exemplo Quantidade Registros
Exemplo Quantidade Registros

_numero_registros is int= HNbRec(cliente)
Info(_numero_registros)

//Blog com Exemplo e video
http://windevdesenvolvimento.blogspot.com.br/2016/07/windev-21-hyperfile-hnbrec-quantidade.html
https://www.youtube.com/watch?v=t_hk176KDbg
De matos AMARILDO
Jul. 16 2016