[Lazarus] MySQL5.1 and Sum(DataLength(FIELD))

[Andrew Brunner]

On Sun, Oct 17, 2010 at 5:24 AM, Joost van der Sluis <joost at cnoc.nl> wrote:

> Then it probably doesn't recognize the field-type. But it should give an
> exception while opening the dataset in that case. Now I know that there
> are a lot of people who send in bug-reports that no exception should be
> given but that the fields should be ignored... But afaik this never
> changed. (It would be wrong, if it did)

I guess I gotta run this in debug mode an trace into the problem.

> So you are really sure you don't get an exception when you try to open
> the dataset? (Btw: you DID open the dataset, didn't you?)

The problem happens with using transaction and execSQL or with just
Query.Open. I tried both (at least last night).

> What happens when you do a simple 'select ITMDAT as TesT from ...' ?

No exceptions.  Just no field representing the Sum of DataLength