alienhunter Active Member Licensed User Longtime User Oct 22, 2015 #1 Hi when i upload to a sqllite db the decimals are lost some how ... i do not get it .. I tried all kinds of sq-lite of Types for the column but it is always off .. I am using Code: Copy NumberFormat2(dist,1,4,4,False) but some how it is always off points jpg are correct in "error" column dbpoints.jpg is off in column 4 any clue ? thanks AH Attachments points.jpg 178 KB · Views: 716 dbpoints.jpg 86.2 KB · Views: 641
Hi when i upload to a sqllite db the decimals are lost some how ... i do not get it .. I tried all kinds of sq-lite of Types for the column but it is always off .. I am using Code: Copy NumberFormat2(dist,1,4,4,False) but some how it is always off points jpg are correct in "error" column dbpoints.jpg is off in column 4 any clue ? thanks AH
alienhunter Active Member Licensed User Longtime User Oct 23, 2015 #3 Thank you Klaus, it works now see point/line25 i did not get the value as double and updated the sqllite as string Code: Copy Do While cur3m.NextRow czm=cur3m.GetDouble("col3") listzm.Add(czm) Loop Vielen dank gruss Alfred Attachments apppoints.jpg 105.8 KB · Views: 645 db2points.jpg 17.2 KB · Views: 657
Thank you Klaus, it works now see point/line25 i did not get the value as double and updated the sqllite as string Code: Copy Do While cur3m.NextRow czm=cur3m.GetDouble("col3") listzm.Add(czm) Loop Vielen dank gruss Alfred
