|
|
|
|
|
|
|
|
|
|
<Source>.StatNbDuplicates (Function) In french: <Source>.StatNbDoublon
  Available only with these kinds of connection
Returns the number of duplicates for a given key item. This number of duplicates was calculated during the last calculation of statistics.
// Calculate statistics about duplicates on the CustName key of the Customer data file
ResStat = Customer.StatNbDuplicates(CustName)
Syntax
<Result> = <Source>.StatNbDuplicates([<Key item>])
<Result>: Integer Number of duplicates found. 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>.StatNbDuplicates will use the last item used by the last HFSQL management function (function starting with "H"). Remarks - The statistics can also be updated by <Source>.Index. <Source>.Index and <Source>.StatCalculate are the only two functions that update the statistics of the data file.
- In the HFSQL Classic data files, the statistical calculations can only be performed on key items.
- The number of duplicates corresponds to the total numer of entries less the number of distinct values. For example, if the entries are the numbers: 1, 3, 3, 5, 5, 5, 6, 7, 7, 7, 8, 9, then the number of duplicates is 12-7 = 5.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|