Re: [sqlite] Sqlite SUM erroneous return value

On Jun 4, 2008, at 6:18 AM, [EMAIL PROTECTED] wrote: >> >> I have created a table with the following values. >> >> CREATE TABLE [test] ([Id] TEXT DEFAULT(0), [PV] REAL DEFAULT(0)); >> >> insert into [test] ("Id", "PV") values ('485314EL', '-720.237'); >> insert into [test] ("Id", "PV") values

[sqlite] Sqlite SUM erroneous return value

Hi, I have created a table with the following values. CREATE TABLE [test] ([Id] TEXT DEFAULT(0), [PV] REAL DEFAULT(0)); insert into [test] ("Id", "PV") values ('485314EL', '-720.237'); insert into [test] ("Id", "PV") values ('485314L', '-720.237'); insert into [test] ("Id", "PV") values

[sqlite] Sqlite SUM erroneous return value

Sent from my BlackBerry® wireless device -Original Message- From: "Van Ry, Wayne" <[EMAIL PROTECTED]> Date: Wed, 4 Jun 2008 14:17:33 To:<[EMAIL PROTECTED]> Subject: FW: Sqlite SUM erroneous return value >__ > From: Van Ry, Wayne