Re: RFC : Correcting some problems in rounding/number handling

[Bill Gribble]

Christopher Browne <[EMAIL PROTECTED]> writes:
> This generality interferes with the possibility of having an SQL
> engine do the calculation for you, via:
>   select sum( value ) from txntable where currency = "USD"
>    and date = something;

I'm not SQL-literate, but it seems pretty clear that your example
would work just as well in the case where numerator and denominator
are stored separately.  You are selecting the currency name as a
"validation gate" where you could just as easily check the currency in
the account, once, and test that all denominators are the same (they
must be) before summing the numerators.

Bill Gribble



--
Gnucash Developer's List
To unsubscribe send empty email to: [EMAIL PROTECTED]