I have a query in my sqlite like this
String query = "select id_temp, id_product, supplier_name, category_name, product_name, " +
"product_brand, product_unit_measure, product_dimension, product_purchase_price, product_selling_price," +
"quantity, product_purchase_price * quantity as subtotal from table_temp";
but the result from subtotal
return scientific number 4.17505e+06. The value of product_purchase_price = 41750.5
and quantity = 100
and the data type for both field is numeric
if we perform an addition operation it must be 4175050
. Any idea why this result happen? Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire