TZQuery field size limit on aggregate functions
Posted: 26.08.2011, 07:49
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:
The record set returned by query looks ok, having [Message] correct field size, 1024
but when I use:
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
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 Eventsbut when I use:
Code: Select all
SELECT Max(RecordNr), Sum(Occured), Message FROM Events GROUP By MessageIs 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