problem with zeos and sqlite3
Posted: 14.02.2006, 20:27
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.
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.
