mardi 15 septembre 2015

SQLite ROUND showing error in Trigger Formulas

I am using SQLiteStudio under Debian x86

enter image description here

in the above fig as shown my Trigger for Production is evaluating to zero whereas it shouldn't enter image description here

these are my data types

enter image description here

problem is resolved using ROUND with Efficiency

My question is that Production is evaluated zero only for values having Efficiency as whole number (no decimals) which is rectified via ROUND in the last fig. However ambiguity remains because Elements as well as Load (in some instances) are also whole numbers?

Aucun commentaire:

Enregistrer un commentaire