AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Statistics on composite keys
  • Miscellaneous
WINDEV
WindowsLinuxJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac Catalyst
Otros
Procedimientos almacenados
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.
Ejemplo
// Calculate statistics for the CustomerName key in the Customer data file
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"])

Miscellaneous

Componente: wd300hf.dll
Versión mínima requerida
  • Versión 25
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 26/09/2024

Señalar un error o enviar una sugerencia | Ayuda local