Using SQL SERVER 2014.
After last update 8.1.050 do not work in GRID queries with global variabLES type: WHERE rc.CodSito = ‘[…]’
When I create error appears: “Grid fields undefined”
Example:
SELECT TOP 5 rc.DataRic, rc.NoteAzioni, rc.DataEff, ma.codpercric, rc.CodOperatRic FROM RicCli rc
LEFT JOIN ON mio_assegnaric but ma.codric = rc.Codice
WHERE rc.CodSito = ‘[codsito]’
The problem occurs when using a query with TOP … and a global variable enclosed in single quotes ‘[…]’
The fields do not appear in Grid / FieldPositions