Share this post

Link to post

Share on other sites

iamtheky 633

but it works as expected for every other attempt (of x.275 and x.285), those are the only ones I have been able to break it with so far. Definitely seems odd, maybe a lesson in floating-point math is upcoming.

Share this post

Link to post

Share on other sites

Yashied 196

The problem is that if the internal representation of the floating point number is 0.2849... instead of 0.285, the rounding algorithm will incorrectly assume the last digit is a 4 and not a 5 and then return the lower number instead of the higher one.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)