User Tools

Site Tools


query_2:correct_ar8percision

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

query_2:correct_ar8percision [2020/05/22 07:38]
sweitmann created
query_2:correct_ar8percision [2020/05/22 07:42] (current)
sweitmann
Line 1: Line 1:
 Two queries: Two queries:
  
-  UPDATE ar SET amount=ROUND(amount::numeric,2), netamount = round(netamount::numeric,2), paid=ROUND(paid::numeric,2), fxamount = ROUND(fxamount::numeric,2), fxpaid = ROUND(fxpaid::numeric,2) WHERE amount - paid BETWEEN 0.0009 AND 0.009;+  UPDATE ar SET amount=ROUND(amount::numeric,2), netamount = round(netamount::numeric,2), paid=ROUND(paid::numeric,2), fxamount = ROUND(fxamount::numeric,2), fxpaid = ROUND(fxpaid::numeric,2) WHERE amount - paid BETWEEN 0.00001 AND 0.009;
  
 and  and 
  
-  UPDATE ar SET amount=ROUND(amount::numeric,2), netamount = round(netamount::numeric,2), paid=ROUND(paid::numeric,2), fxamount = ROUND(fxamount::numeric,2), fxpaid = ROUND(fxpaid::numeric,2) WHERE paid - amount BETWEEN 0.0009 AND 0.009;+  UPDATE ar SET amount=ROUND(amount::numeric,2), netamount = round(netamount::numeric,2), paid=ROUND(paid::numeric,2), fxamount = ROUND(fxamount::numeric,2), fxpaid = ROUND(fxpaid::numeric,2) WHERE paid - amount BETWEEN 0.00001 AND 0.009;
  
query_2/correct_ar8percision.txt ยท Last modified: 2020/05/22 07:42 by sweitmann