Problem with LargeInt fields and QuickReport (D6 pro)
Posted: 01.04.2007, 19:19
Hi there,
I have been using Zeos for years. Now I updated from 6.5 to the latest (6.6.1 beta) version and noticed strange problems with LargeInt-Fields (mysql 5.0):my quick-reports do not recognize these fields!
Two examples:
- if I use an expression like 'this is field number ' + myquery.largeintfield, the result is "Undefined field type"
- if I want quick report to use the grouping feature the largeint fields are ignored.
I tried to do this dirty hack:
- add a new calculated field to the field list of myquery
- use the "myquery.onCalcFields" and convert the largeint-field into a "normal" int-field simply by
intfield.asinteger := largeintfield.asinteger
And... this works!
In addition, my SMExportSuite crashes when trying to export a dataset, which I suppose is also caused by the field definitions.
Is there any help?
Thanks!
Heiko.
I have been using Zeos for years. Now I updated from 6.5 to the latest (6.6.1 beta) version and noticed strange problems with LargeInt-Fields (mysql 5.0):my quick-reports do not recognize these fields!
Two examples:
- if I use an expression like 'this is field number ' + myquery.largeintfield, the result is "Undefined field type"
- if I want quick report to use the grouping feature the largeint fields are ignored.
I tried to do this dirty hack:
- add a new calculated field to the field list of myquery
- use the "myquery.onCalcFields" and convert the largeint-field into a "normal" int-field simply by
intfield.asinteger := largeintfield.asinteger
And... this works!
In addition, my SMExportSuite crashes when trying to export a dataset, which I suppose is also caused by the field definitions.
Is there any help?
Thanks!
Heiko.