SELECT
COALESCE(_Owner,_Code) AS _ACode,
IF (_DatePaid BETWEEN DATE '2018-10-05' AND DATE '2018-10-31', IF (_InOut = '+ ', SUM(COALESCE(Analysis._Income, 0)), SUM(COALESCE(Analysis._Expenditure,
0))), 0) AS "Col_1",
IF (_DatePaid BETWEEN DATE '2018-10-05' AND DATE '2019-10-04', IF (_InOut = '+ ', SUM(COALESCE(Analysis._Income, 0)), SUM(COALESCE(Analysis._Expenditure,
0))), 0) AS "Col_13"
FROM Analysis
JOIN Coding ON Analysis._fkCoding = Coding._Code
JOIN Transactions ON Transactions._ID = Analysis._fkTransaction
WHERE _DatePaid BETWEEN DATE '2018-10-05' AND DATE '2019-10-04'
GROUP BY _ACode
union
SELECT
'TOTAL'+_InOut AS _ACode,
IF (_DatePaid BETWEEN DATE '2018-10-05' AND DATE '2018-10-31', IF (_InOut = '+ ', SUM(COALESCE(Analysis._Income, 0)), SUM(COALESCE(Analysis._Expenditure,
0))), 0) AS "Col_1",
IF (_DatePaid BETWEEN DATE '2018-10-05' AND DATE '2019-10-04', IF (_InOut = '+ ', SUM(COALESCE(Analysis._Income, 0)), SUM(COALESCE(Analysis._Expenditure,
0))), 0) AS "Col_13"
FROM Analysis
JOIN Transactions ON Transactions._ID = Analysis._fkTransaction
WHERE Transactions._DatePaid BETWEEN DATE '2018-10-05' AND DATE '2019-10-04'
GROUP BY _InOut

---

 Comments

---

The issue here was that ElevateDB was not ignoring hidden columns used for internal expression handling, so any mismatch between the layout of the hidden columns would cause such an error.

---

 Resolution

---

Fixed Problem on 7/3/2019 in version 2.31 build 7

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial