Error Sql dynamic group-by when you click on the detail link.

Error Sql dynamic group-by when you click on the detail link.
Alleged debug:

(mssqlnative): set dateformat ymd [HR][/HR] [HR]/HR: SELECT count() from Magaz m LEFT JOIN TipDis td ON td.Codice=m.CodTipologiaMacchina LEFT JOIN FamDis fd ON fd.Codice=td.CodFamigliaDistributore1 LEFT JOIN FamDis fd1 ON fd1.Codice=td.CodFamigliaDistributore2 LEFT JOIN FamDis fd2 ON fd2.Codice=td.CodFamigliaDistributore3 LEFT JOIN SitCli sc ON sc.Codice=m.CodSito LEFT JOIN mio_sistemimasterAE ma ON ma.ecs1=m.ECS1 AND m.ECS1 != ‘’ where m.TipoMag=‘3’ and ( = AURA BAR ELETTRONIC VAPOR) [HR][/HR]102: SQLState: 42000 Error Code: 102 Message: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near ‘=’.
ADOConnection._Execute(SELECT count(
) from Magaz m LEFT JOIN TipDis td ON td.Codice=m.CodTipologiaMacchina LEFT JOIN FamDis fd ON fd.Codice=td.CodFami…, false)[SIZE=-1] % line 1095, file: adodb.inc.php[/SIZE] ADOConnection.Execute(SELECT count(*) from Magaz m LEFT JOIN TipDis td ON td.Codice=m.CodTipologiaMacchina LEFT JOIN FamDis fd ON fd.Codice=td.CodFami…)[SIZE=-1] % line 859, file: grid_distributori_190_restore_grid.class.php[/SIZE] grid_distributori_190_restore_grid.inicializa()[SIZE=-1] % line 149, file: grid_distributori_190_restore_grid.class.php[/SIZE] grid_distributori_190_restore_grid.monta_grid(0)[SIZE=-1] % line 3025, file: index.php[/SIZE] grid_distributori_190_restore_apl.controle()[SIZE=-1] % line 4331, file: index.php[/SIZE]

SELECT count(*)
from Magaz m
LEFT JOIN TipDis td ON td.Codice=m.CodTipologiaMacchina
LEFT JOIN FamDis fd ON fd.Codice=td.CodFamigliaDistributore1
LEFT JOIN FamDis fd1 ON fd1.Codice=td.CodFamigliaDistributore2
LEFT JOIN FamDis fd2 ON fd2.Codice=td.CodFamigliaDistributore3
LEFT JOIN SitCli sc ON sc.Codice=m.CodSito
LEFT JOIN mio_sistemimasterAE ma ON ma.ecs1=m.ECS1 AND m.ECS1 != ‘’
where m.TipoMag=‘3’ …

until here it seams to be ok , but what's this?  

and ( = AURA BAR ELETTRONIC VAPOR)

Yes, I saw the error:
… and ( = AURA BAR ELETTRONIC VAPOR)…
but the query is self-generated by scriptcase.

Hello,

I can not simulate the problem. Could you make a simplified example about this problem and email me the exported application along with the CREATE of the tables involved?
E-mail: j.lennon@netmake.com.br