PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
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
Returns the number of entries for a given key item. This number was calculated during the last statistical calculation.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Calculate the statistics on the CustName key found in 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 data file used.
<Key item>: Optional character string (with or without quotes)
Name of key item used to perform the statistical calculation. 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 : wd250hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment