ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Example: Number of records in a data file
Example: Number of records in a data file
HFSQL ClassicHFSQL Client/ServerNative Connectors (Native Accesses) The following example displays various information about the number of records found in a CUSTOMER file.
// Displays information about the file
Info("The CUSTOMER file contains " + ...
HNbRec(CUSTOMER, hStateActive) + " active records, " + ...
HNbRec(CUSTOMER, hStateCrossed) + " crossed records, " + ...
HNbRec(CUSTOMER, hStateDel) + " deleted records, " + ...
" for a total of " + HNbRec(CUSTOMER, hStateAll) + " records")
Minimum version required
  • Version 9
This page is also available for…
Comments
Exemplo de HnbRec e Gauge
Exemplo de HnbRec e Gauge

EDT_quantidade_tabela=HNbRec(cliente)
EDT_contador=0
FOR EACH cliente
EDT_contador ++
//Mostra progresso
Gauge(EDT_contador,EDT_quantidade_tabela)
END
//finalizando progresso
Gauge()

//Blog com Video e Exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/09/aula-922-windev-23-hyperfile-hnbrecgauge.html
https://www.youtube.com/watch?v=ou5X4tSXq78

http://windevdesenvolvimento.blogspot.com.br/2016/07/windev-21-hyperfile-hnbrec-quantidade.html
https://www.youtube.com/watch?v=ou5X4tSXq78
De matos
26 Sep. 2016

Last update: 05/26/2022

Send a report | Local help