Using MySql (mariadb) database when there are JOINs in the main query
all sql fields are seen as TEXT fields.
example the query Grid Application:
SELECT bi.Codice,bi.DataMov,bi.CodDistributore FROM BatInc bi
LEFT JOIN Magaz m ON m.Codice=bi.CodDistributore
all fields are seen from scriptcase as text fields.
If we remove the JOIN fields are recognized correctly.