ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Returns the number of entries for a given key item. This number was calculated during the last statistical calculation.
Example
// Calculate statistics about the CustName key from the Customer data file
ResStat = Customer.StatNbRec(CustName)
Syntax
<Result> = <Source>.StatNbRec([<Key item>])
<Result>: Integer
Number of entries found for the specified item.
Corresponds to the hInvalidRecNum constant if:
  • the statistics have never been calculated for the specified item.
  • the statistics are not supported by the specified type of item. HFSQL allows you to perform statistical calculations on key items only.
<Source>: Type corresponding to the specified source
Name of the data file used.
<Key item>: Optional character string
Name of the key item used to calculate statistics. If this name is not specified, <Source>.StatNbRec will use the last item used by the last HFSQL management function (function starting with "H").
Remarks
Component: wd290hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/06/2023

Send a report | Local help