mardi 24 février 2015

Android SQLite query return scientific number format

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