pcsoft.us.windevCopyright 2026, PC SOFT6 Aug 2018 11:50:09 Z8 Nov 2007 16:53:47 ZHello, I have defined a query (QRY_A) which using a Subquery (QRY_B) for a specific Field (defined as parameter FIELD_A). The Subquery also has a parameter (FIELD_B) which will be filled by a field on my window. It seems that the Parameter for the Subquery is ignored if I'm setting the Parameter for the Query (i guess the reason is because the query will be called internal). I'm using the following code: QRY_B.FIELD_B = "TEST" HExecuteQuery(QRY_A) Doing it this way does not work. Is there any other way the define the Parameter FIELD_B for QRY_A? Thanks a lot. Best regards Andreas30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/10600-query-with-subquery-parameter/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)Wim MEURISSEpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/10600-query-with-subquery-parameter-66497/read.awp6 Aug 2018 11:50:09 ZHello, I got this working this way: QRY_B.param1 = value1 QRY_B.param2 = value2 if HExecuteQuery( QRY_B ) then if HExe…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/10600-query-with-subquery-parameter-66497/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/10600-query-with-subquery-parameter-66497/read.awpQuery with Subquery /w Parameteradolleschalpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/10600-query-with-subquery-parameter-10603/read.awp8 Nov 2007 18:33:58 Z>... >>I'm using the following code: >>QRY_B.FIELD_B = "TEST" >>HExecuteQuery(QRY_A) >>Doing it this way does not wo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/10600-query-with-subquery-parameter-10603/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/10600-query-with-subquery-parameter-10603/read.awpQuery with Subquery /w ParameterNoSPAM-mnobspcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/10600-query-with-subquery-parameter-10602/read.awp8 Nov 2007 18:13:55 Z... >I'm using the following code: >QRY_B.FIELD_B = "TEST" >HExecuteQuery(QRY_A) >Doing it this way does not work. I…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/10600-query-with-subquery-parameter-10602/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/10600-query-with-subquery-parameter-10602/read.awpQuery with Subquery /w Parameter