Hi again and sorry when this Posting notreally required.
Few days ago i posted following problem, a testcase was required and I attached
a testcase in my answer. Now i'm not sure if the testcase reciving the
MaillingList, so i send the testcase again. Should be the testcase already
arrived
Hi,
I have a problem with a Select which subtract two Sum-Values.
Normally the correct value of my Select should be 0 but when ich run my Select
Sqlite bring back as Result 9.09494
This is my Select:
select kto,sum(neg-pos) from
(
select kto1 kto,sum(betrag) pos,sum(0) neg from buchungen where
On Thu, Mar 8, 2012 at 8:39 AM, marku...@web.de wrote:
Hi,
I have a problem with a Select which subtract two Sum-Values.
Normally the correct value of my Select should be 0 but when ich run my
Select Sqlite bring back as Result 9.09494
Do you have a test case that we can run?
This is my
Here is the Testcase with exact the same Table and Data
All other Subtract-Results of the Sum-Values which i controlled are ok, only
with kto=3020 its the wrong value
Markus
___
Ihr WEB.DE Postfach immer dabei: die kostenlose WEB.DE Mail