On Windows XP: Did select round(0.95, 1) with your VB wrapper, gives 0 Same in the free SQLite2006 Pro (from OsenXPSuite) and same result.
RBS -----Original Message----- From: Olaf Schmidt [mailto:[EMAIL PROTECTED] Sent: 10 June 2007 19:35 To: sqlite-users@sqlite.org Subject: Re: [sqlite] error in round-function? > > select round(0.95, 1) > 0.9 > > select round(9.95, 1) > 9.9 > > select round(0.995, 2) > 0.99 > > select round(9.995, 2) > 9.99 > (3.3.17 here) As it should be, hmm. On what OS have you tested? If on windows, was it a GCC-compile or a MS-VC-compile? Olaf -- View this message in context: http://www.nabble.com/error-in-round-function--tf3897765.html#a11051093 Sent from the SQLite mailing list archive at Nabble.com. ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
