PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → [WD20] Embedded Query in Report
[WD20] Embedded Query in Report
Iniciado por kevin, 03,nov. 2015 13:51 - 2 respuestas
Publicado el 03,noviembre 2015 - 13:51
Hi,

Is there any way to programmically get the next record set returned by the query. The report obviously does this automatically but in one circumstance I need to check the contents of the next record.

Best Regards,

Kevin
Publicado el 03,noviembre 2015 - 16:40
Hi,

Maybe you can try Hreadnext(queryName), do the check that you want to do and then return to the previous HReadPrevious(queryName) in order to return to the previous record and continue the normal processing of the query.

(I haven't tested it, so I don't know if it works :( )
Bruno
Publicado el 04,noviembre 2015 - 10:28
Hi,

Thanks for your help, I did originally look into HREADNEXT but gave up as I couldn't no matter what name the embedded query correctly as the first parameter. But you post made me look into this again and here is how I did it

HReadNext(RPT_Invoice..SourceName)

where RPT_Invoice is the name of the report.

Thank-you very much, and you correct said that a HREADPREVIOUS needs to be done afterwards.

Kevin.