Hi, Tom,
Regarding: "Adding values to att0 (one of the numeric columns) gives this odd result:" I tried this on win xp 32 using the sqlite3.exe command-line interface and for me it *does* behave as expected. I tried it under sqlite 3.5.5 and under 3.6.6.2. I wonder if PHP (or something) is having a problem with the larger number of digits in the result when rowid=2? sqlite> select itemid, att0, (att0 + 0.95) dx from map; 0|0.0290534291416|0.9790534291416 1|-0.0737001597881|0.8762998402119 2|-0.957751333714|-0.00775133371400005 3|-0.229464128613|0.720535871387 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
