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
Does 7.2 fix TWideField aggregates? If so, how to install?
-
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: Does 7.2 fix TWideField aggregates? If so, how to install?
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
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?
That link gives me the 404. Not this 404: https://upload.wikimedia.org/wikipedia/ ... 4vitfr.jpgmarsupilami 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
The other one.
---
Mark
-
- Platinum Boarder
- Posts: 1956
- Joined: 17.01.2011, 14:17
Re: Does 7.2 fix TWideField aggregates? If so, how to install?
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
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