problem with zeos and sqlite3

[robertoborchardt]

hi,
i'm using delphi 7 + zeosdbo 6.5.1 (cvs - february 10,2006) + sqlite 3.3.3 and i think have a problem
the result of TZQuery and TZReadOnlyQuery (query and subquery) with the aggregate functions SUM(), AVG(), TOTAL(), MIN(), MAX() in SELECT always return a STRING, instead FLOAT
(select id, name, sum(value) from table)
with sqlite 2.8.16 and 3.3.4 result the same problem

combining UPDATE + SELECT has no problem (sqlite3)
(update table1 set value = (select sum(value) from table2 where id=table1.id)

when use zeosdbo-6.5.1-alpha (release october 13,2005) + sqlite 2.8.16 works fine
with mysql 4.1.12 works fine too

is this a bug or has another way to do this now ?

thanks ... and congratulations to developer team
roberto.

[Michael]

Hi robertoborchardt,

we will have to check it. Could you please create a bug report on SourceForge? Would be great!

Regards!

Michael.

[robertoborchardt]

thank you Michael,

bug report on SourceForge done.

regards
roberto