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
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