Does 7.2 fix TWideField aggregates? If so, how to install?
Posted: 29.09.2015, 02:02
Hi
We are converting a project from MySQL to SQLite. The DB library we are using is Zeos 7.1.4. We have run into a problem: SUM(field) shows up in TZQuery as a TWideStringField. We have code that uses the field type to alter behaviour. so that functionality is not working correctly. We need SELECT SUM(Amount) to return a float, and COUNT(0) to return an integer.
On stackoverflow someone suggested that Zeos 7.2 might fix that problem. Is that correct? If so, how do we install 7.2?
TIA
Mark
We are converting a project from MySQL to SQLite. The DB library we are using is Zeos 7.1.4. We have run into a problem: SUM(field) shows up in TZQuery as a TWideStringField. We have code that uses the field type to alter behaviour. so that functionality is not working correctly. We need SELECT SUM(Amount) to return a float, and COUNT(0) to return an integer.
On stackoverflow someone suggested that Zeos 7.2 might fix that problem. Is that correct? If so, how do we install 7.2?
TIA
Mark