Variant problem with Crosstable/MySQL/Delphi

Hello,

I tried to build a Crosstable with integer fields and got a Variant conversion error.

Configuration of my system:
-Delphi 5
-FastReport 3.18
-MySQL 4

I solved the problem with a reeeally strange query...

select B_Ist + 0.0 as Be, Du, Sph, Zyl, Nr_I, Nr_A from inv
where Nr_I = 1009
and Nr_A = 1200
and B_Ist > 0

I added the 0.0 to B_Ist and so i got valid values and no variant conversion error.
But anyway, this couldn't be the problem, because the FastReport seems to be buggy.
Please, dear developers, if anybody has an idea how I can get rid of this conversion error a little bit more elegant, i would be happy!
Thanks

mostpresse

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.