PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Functions that modify the result of HOut
  • Various
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
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 (with or without quotes)
Name of data file, filter, view or query onto which a positioning attempt was performed.
If this name is not specified, HOut handles the last data file (filter, view or query) used by the last function for HFSQL Mobile management (starting with the letter H).
Remarks

Functions that modify the result of HOut

The following functions modify the value returned by HOut:

Various

  • HOut corresponds to the h.Out variable available in WINDEV 5.5. This variable is available for backward compatibility.
  • Once a locked record was read, no reading is performed on the data file (HErrorLock returns True and HOut returns True).
    Therefore, if this reading is performed in a browse loop on an HFSQL data file, this browse is interrupted.
Component : wd250hf.dll
See also
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