ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Functions that modify the result of HOut
  • Miscellaneous
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Used to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query.
HReadFirst(Customer, Name)
WHILE HOut() = False
// Process the record
HReadNext(Customer, Name)
END
Syntax
<Result> = HOut([<Data file>])
<Result>: Boolean
  • True if attempt to position on a record located outside the data file, filter, view or query. In this case, the current record corresponds to the one before the move operation.
  • False if no problem occurred: the current record belongs to the data file, filter, view or query.
<Data file>: Optional character string
Name of data file, filter, view or query onto which a positioning attempt was performed.
If this name is not specified, HOut will use the last data file (filter, view or query) used by the last HFSQL function (function starting with "H").
Remarks

Functions that modify the result of HOut

The following functions modify the value returned by HOut:

Miscellaneous

  • HOut corresponds to the h.Out variable available in WINDEV 5.5. This variable is kept for backward compatibility.
  • Once a locked record is read, the data file is not read (HErrorLock returns True and HOut returns True).
    Therefore, if the read operation is performed while looping through an HFSQL data file, the iteration is interrupted.
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Video While Hout


https://youtu.be/tKbizR8FikY

https://windevdesenvolvimento.blogspot.com/2019/04/dicas-2076-windev-webdev-mobile-tabela.html

// BTN_GERA_TABELA

TableDeleteAll(TABLE_CLIENTES)
HExecuteQuery(QRY_CLIENTE_LER)
HReadFirst(QRY_CLIENTE_LER)
WHILE HOut()=False
HReadNext(QRY_CLIENTE_LER)
TableAddLine(TABLE_CLIENTES,QRY_CLIENTE_LER.clienteid,QRY_CLIENTE_LER.nome)
END
amarildo
16 Apr. 2019
Example
https://forum.pcsoft.fr/fr-FR/pcsoft.br.windev/3133-winformatica-example-hexecutesqlquery-with-break-and-filter-custom/read.awp
BOLLER
29 Mar. 2019
Example HexecuteSqlQuery with WHILE HOut() = False
numero_corrida is int = 0

MyProcedureUltimaCorrida is Data Source

IF HExecuteSQLQuery(MyProcedureUltimaCorrida, ConnNativa, hQueryWithoutCorrection,"NG0002_Procedure_UltimaCorrida") THEN

HReadFirst(MyProcedureUltimaCorrida, num_corrida)

WHILE HOut() = False

ok = HReadNext(MyProcedureUltimaCorrida, num_corrida)

numero_corrida = MyProcedureUltimaCorrida.num_corrida

END

ELSE

Error(HErrorInfo())

END

Trace(numero_corrida)
BOLLER
29 Mar. 2019

Last update: 06/04/2024

Send a report | Local help