Signori, ho ripreso questo vecchio post : https://www.b4x.com/android/forum/threads/creare-un-grafico-con-b4a.77369/
e l'ho riprodotto: ora mi da errore, come mai?
e l'ho riprodotto: ora mi da errore, come mai?
B4X:
ResponseError. Reason: , Response: SELECT MONTHNAME(Data) As mese, SUM(incasso) As totale FROM incassi WHERE n_macchina = 3 GROUP BY MONTH(Data)\nExpression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxdb.incassi.data' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT MONTHNAME(Data) As mese, SUM(incasso) As totale FROM incassi WHERE n_macchina = 3 GROUP BY MONTH(Data)\nExpression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxdb.incassi.data' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by