Page 1 of 1
sum of return stringfield as result
Posted: 14.08.2006, 10:52
by muthuhk
Hai
Mysql - Zquery - sum(field) return stringfield resutl, suppose to be numeric type result ?
Muthu
Posted: 16.08.2006, 14:31
by mdaems
Hi Muthu,
I don't know what version you use. It sounds like you have trouble with a mysql5 server returning a new decimal type that wasn't supported by zeos. By now this should be fixed in the 'releases' Ive build and published on
http://users.telenet.be/mdaems or in the SVN repository (testing branch).
If I'm wrong about that mysql thing, let us know what you're trying to do on what configuration.
Mark
zquery return TstrinField instead TfloatField
Posted: 02.09.2006, 16:40
by muthuhk
Hai
i am using zeos latest source (thru svn updated ) , mysql ver 5 (but i chked with old ver of mysql also )
select sum(qty) as ttlqty from table1
return like this
ZQuery1ttlqty: TStringField;
but normlay like postgresql & others return as TFloatfield
is this bug or problem of mysql ?
Muthu