TZQuery field size limit on aggregate functions

[slimbyte]

Hi there,

I'm using TZQuery for a while, but I just noticed a wired thing.
When using aggregate functions within sql query, TZQuery limmit the field size to 256.

More exactly:
Let's say that I have a field [Message] VARCHAR(1024)
Now, if I use:

Code: Select all

SELECT RecordNr, Occured, Message FROM Events

The record set returned by query looks ok, having [Message] correct field size, 1024

but when I use:

Code: Select all

SELECT Max(RecordNr), Sum(Occured), Message FROM Events GROUP By Message

The record set returned by the query, truncate the [Message] field to 255 chars.

Is there any solutin for this? I'm using ZeosLib 6.6.6 - stable; using ado and sqlite-3 protocols (I noticed the issue on both, I don't know the rest)

Thanks