pcsoft.us.windevCopyright 2026, PC SOFT22 Sep 2016 08:39:00 Z20 Sep 2016 10:54:00 ZHello to all I'm trying, without any luck to run this query sSql is string dsMyQuery is data source bRes is boolean bData is boolean sSql="SELECT r.data, G.Descrizione, SUM(r.importo_prestazione) AS tot_imp_prescr, COUNT(*) AS tot_prescr, " sSql+="(SELECT COUNT(*) FROM registro LEFT JOIN PRESTAZIONI ON REGISTRO.TIPO_PRESTAZIONE=PRESTAZIONI.ID " sSql+="WHERE REGISTRO.TIPO_PRESTAZIONE = 1 AND REGISTRO.data = R.DATA AND R.ID_GMT=REGISTRO.ID_GMT) FROM REGISTRO AS r " sSql+=" LEFT JOIN guardie G ON R.id_gmt=g.id " sSql+="LEFT JOIN prestazioni AS P ON R.tipo_prestazione = p.ID " sSql+=" GROUP BY r.data DESC, G.descrizione ORDER BY r.data DESC" bRes=HExecuteSQLQuery(dsMyQuery,hQueryWithoutCorrection,sSql) the result of "bRes" is always False !! Trying copying/pasting the query to a client (SqlYOG), the query is executed correctly. Do am i missing something? Wrong parameters? HF query execution limits?? Tips and tricks are very appreciated. Thanks in advance Gianni30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-59656/read.awp22 Sep 2016 08:39:00 ZCiao Gianni, la funzione HExecuteSQLQuery con il parametro hQueryWithoutCorrection vuole sempre IL NOME DELLA CONNESSIONE com…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-59656/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-59656/read.awp[WD] Limits on Query execution with MySqlguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-59653/read.awp21 Sep 2016 19:44:00 ZHi Tip on using mysql. use HeidiSQl . This is a free tool and it rocks. Windev works great with this tool. regards alla…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-59653/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-59653/read.awp[WD] Limits on Query execution with MySqlguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-59644/read.awp20 Sep 2016 17:29:00 ZHi Fabrice Thanks for the info.. I will try and i will tell your the result. Thanks again Giannihttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-59644/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-59644/read.awp[WD] Limits on Query execution with MySqlguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-solved-59643/read.awp20 Sep 2016 17:24:00 ZHi Gianni if the hexecutequery retuns FALSE, as you stated, then there IS AN ERROR MESSAGE. Your code is just not displayi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-solved-59643/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-solved-59643/read.awp[WD] Limits on Query execution with MySqlguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-solved-59641/read.awp20 Sep 2016 16:51:00 ZHello Fabrice No error messages. The query is not returning data, but only if i build the string containing the query as i po…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-solved-59641/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-solved-59641/read.awp[WD] Limits on Query execution with MySqlguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-59640/read.awp20 Sep 2016 16:32:00 ZHi Gianni, "...the result of "bRes" is always False !!.." ok... but what is the error message? Best regardshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-59640/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59627-limits-query-execution-with-mysql-59640/read.awp[WD] Limits on Query execution with MySql