Page 1 of 1

Does 7.2 fix TWideField aggregates? If so, how to install?

Posted: 29.09.2015, 02:02
by Delphic
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

Re: Does 7.2 fix TWideField aggregates? If so, how to install?

Posted: 30.09.2015, 15:40
by marsupilami
Hello Mark,

you should check out the Zeo 7.2 branch from the subversion using the URL http://svn.code.sf.net/p/zeoslib/code-0 ... esting-7.2.#
Then you can just install it via its usual packages :-)
With best regards,

Jan

Re: Does 7.2 fix TWideField aggregates? If so, how to install?

Posted: 01.10.2015, 02:41
by Delphic
marsupilami wrote: you should check out the Zeo 7.2 branch from the subversion using the URL http://svn.code.sf.net/p/zeoslib/code-0 ... esting-7.2.#
Jan
That link gives me the 404. Not this 404: https://upload.wikimedia.org/wikipedia/ ... 4vitfr.jpg
The other one.

---
Mark

Re: Does 7.2 fix TWideField aggregates? If so, how to install?

Posted: 01.10.2015, 09:01
by marsupilami
Hello Mark,

it seems, that I added some characters that were not meant to be there. Please try this link:
http://svn.code.sf.net/p/zeoslib/code-0 ... esting-7.2
It is meant to be used for the svn checkout command or the respective dialog of Tortoise SVN.

With best regards,

Jan