Hi, I am using the sqlite database which is provide for offline content in gears. While i am executing the queries it is not giving the exact values.
Suppose, if i given select 520/470, then the correct output is 1.1064 (in MySql) and the same if i executed in sqlite it is giving output as 1. What may be the problem? Is sqlite doesn't support the decimal parts? and another problem is, i have to get the max of some column in order to calculate something at that time also it is not giving the exact values Suppose if i give select max(colName) from tblName - it has to give the max in that column suppose in the column if i have values like 10,20,50,90 then the output is 90 if i have values like 10,20,50,90,100 then also the output is 90 if i have values like 10,20,50,90,99.9 then the output is 99.9 if the value in the column greaterthan or equal to 100 then it is not giving the exact value, it is giving the max value below 100 only. What may be the Reason? Thanks in Advance Thanks & Regards, V. Sankar
