I am using SQLiteStudio under Debian x86
in the above fig as shown my Trigger
for Production
is evaluating to zero whereas it shouldn't
these are my data types
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