Re: [SL] Qty Precision

[Armaghan S. <sa...@le...>]

On Wed, May 21, 2008 at 11:04 PM,  <la...@cl...> wrote:
> Looked further into the issue, it seems during the database upgrade the
> qty type had went from real to double precision. It seems weired that the
> value had went from 10.83 to 10.8299999237061 and not 10.8300000000000

Following query should sort out the issue for the past data. New data
will always be correctedly recorded. (Take backup before running it)

UPDATE invoice SET qty = ROUND(qty,2);

Regards
-- 
http://wiki.ledger123.com/

* Purpose-built SQL-Ledger Hosting. Free trial.
* SQL-Ledger VMware Appliance. Free download.

--