|
|
|
|
|
- Statistics on composite keys
- Miscellaneous
<Source>.StatNbRecRange (Función)
 Disponible solo con estos tipos de conexión
Returns an estimate regarding the number of entries for a given key item in a given interval of values. This estimate is deduced from the information obtained during the last statistical calculation.
ResStat = Customer.StatNbRecRange(CustName, "Clark", "Smith")
Sintaxis
<Result> = <Source>.StatNbRecRange([<Key item>, ] <Lower bound> , <Upper bound>)
<Result>: Entero Number of entries found for the specified item in the requested interval. 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>: Tipo de fuente especificada Name of the data file used. <Key item>: Cadena de caracteres opcional Name of the key item used to calculate statistics. If this name is not specified, <Source>.StatNbRecRange will use the last item used by the last HFSQL management function (function starting with "H"). <Lower bound>: Tipo de campo clave Lower value of interval. <Upper bound>: Tipo de campo clave Upper value of interval. Observaciones Statistics on composite keys To perform a statistical calculation on a composite key, use the following syntax:
<Data file>.StatNbRecRange(<Name of composite key>, [<Lower bound of first element of composite key>, <Lower bound of second element of composite key>], [<Upper bound of first element of composite key>, <Upper bound of second element of composite key>, ...]) Example:
Customer.StatNbRecRange(LastName_FirstName, ["Black", "Alicia"], ["Morgan","Vince"])
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|