pcsoft.us.windevCopyright 2026, PC SOFT28 Mar 2015 13:02:00 Z26 Mar 2015 12:06:00 ZHello to all I'm trying to extract some value from a MySql db based on this query sSql is string dsMyQUery is Data Source bRes is boolean bDati is boolean nAnni is int=EditEtaAnniRis nMesi is int=EditEtaMesiRis nGiorni is int=EditEtaGiorniRis nRisposte is int=EDT_Risposte_esatte sSql="SELECT * FROM tfl_valori WHERE (" sSql+=nAnni+" BETWEEN eta_anni_min and eta_anni_max)" sSql+=" AND ("+nMesi+" BETWEEN eta_mesi_min and eta_,mesi_max)" sSql+=" AND ("+nGiorni+" BETWEEN eta_giorni_min and eta_giorni_max)" sSql+=" AND ("+nRisposte+" BETWEEN val_min and val_max)" sSql+=" AND tipo='C'" bRes=HExecuteSQLQuery(dsMyQUery,hQueryDefault,sSql) IF bRes THEN bDati=HReadFirst(dsMyQUery) IF bDati THEN STC_esatte=dsMyQUery.val_percentile+"°" END END The 'bRes' field returns a 'False' value after the execution of the query. And the 'HErrorInfo" says "Error in the SQL code of query. Unable to initialize the query. Unexpected word: , If i execute this query using MySql Admin client the query is correct and i see the result correctly... What does it means: Unxexpected word: , ???? Why this different beahviour? Tips and trick are welcome. Thanks in advance Gianni30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51221/read.awp28 Mar 2015 13:02:00 ZHi Gianni, are you sure you checked the sSql variable before execution? Look at your second line - the following: sSql+=nAn…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51221/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51221/read.awp[WB17] Error on initialization of a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51210/read.awp26 Mar 2015 17:33:00 ZCould be your field names, if ones called name or count or total etc.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51210/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51210/read.awp[WB17] Error on initialization of a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51209/read.awp26 Mar 2015 15:38:00 ZHello to all Thanks for your suggestions... Giannihttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51209/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51209/read.awp[WB17] Error on initialization of a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51199/read.awp26 Mar 2015 14:19:00 ZHi there, In MSSQL we use: bRes=HExecuteSQLQuery(dsMyQUery,hQueryWithoutCorrection,sSql) So, Windev does not change any…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51199/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51199/read.awp[WB17] Error on initialization of a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51208/read.awp26 Mar 2015 14:17:00 ZHi Gianni There is a good chance that your problem comes from hQueryDefault... Try with hwithoutcorrection, as you are typing…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51208/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51208/read.awp[WB17] Error on initialization of a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51205/read.awp26 Mar 2015 13:38:00 ZHello Arie I confirm. The error "Error in the SQL code of query. Unable to initialize the query" continues to appear, despite…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51205/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51205/read.awp[WB17] Error on initialization of a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51204/read.awp26 Mar 2015 13:12:00 ZArie, Yes, i did a copy/paste from the "sSql" field that contains the generated sql script and executed in SqlYog (a MySql to…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51204/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51204/read.awp[WB17] Error on initialization of a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51203/read.awp26 Mar 2015 12:53:00 ZGiannni, Can you grab the generated SQL from within the debugger (put it in the "watch" area). And then test it in mysql adm…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51203/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51203/read.awp[WB17] Error on initialization of a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51202/read.awp26 Mar 2015 12:48:00 ZHello Arie Despite the correction of typos in the query string, i'm unable to obtain the result from it. the "HErrorInfo" …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51202/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51202/read.awp[WB17] Error on initialization of a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51201/read.awp26 Mar 2015 12:31:00 ZHi Arie Yes...now i see the "," before "mesi_max" You have an eagle eye :D Thanks Giannihttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51201/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51201/read.awp[WB17] Error on initialization of a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51200/read.awp26 Mar 2015 12:21:00 ZGianni, it looks like you made a typo BETWEEN eta_mesi_min and eta_,mesi_max) should be BETWEEN eta_mesi_min and eta_mesi_…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51200/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51197-wb17-error-initialization-query-51200/read.awp[WB17] Error on initialization of a query