pcsoft.us.windevCopyright 2026, PC SOFT26 Oct 2017 11:34:00 Z26 Oct 2017 11:13:00 ZHello, Im using HExecuteSQLQuery to create Dynamic queries eg. THEANALYTICNAME = Total_Charges HExecuteSQLQuery(CustomerQry, "SELECT " + THEANALYTICNAME +" FROM " ... the THEANALYTICNAME is the dynamic part, the query all works fine but i cant read the result res = CustomerQry.THEANALYTICNAME shows an error saying THEANALYTICNAME is not part of the query. Ive tried res = CustomerQry +"."+ {THEANALYTICNAME,indItem} but no joy anyone know a solution to this? cheers ISO30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63106-hexecutesqlquery-result-wd22/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63106-hexecutesqlquery-result-wd22-63108/read.awp26 Oct 2017 11:34:00 ZPerfect many thanks Peter. :spos:https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63106-hexecutesqlquery-result-wd22-63108/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63106-hexecutesqlquery-result-wd22-63108/read.awpHExecuteSQLQuery Result [WD22]guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63106-hexecutesqlquery-result-wd22-63107/read.awp26 Oct 2017 11:22:00 ZHey ISO, Your indirection usage is wrong at first sight. Use "res = {CustomerQry +"."+ THEANALYTICNAME,indItem}" instead. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63106-hexecutesqlquery-result-wd22-63107/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63106-hexecutesqlquery-result-wd22-63107/read.awpHExecuteSQLQuery Result [WD22]