Re: [sqlite] Re: Problem flushing double

precision is set to 30 By doing this way, I expected the INSERT command use a string whose double representation would be exactly writtendouble. thank you Stéphane PS: Thanks Igor for the links, it's exactly what I was looking for (and even more :) ) At 14:52 12/09/2007, Igor Tand

[sqlite] Problem flushing double

Hello, If you do: INSERT INTO myTable VALUES('0.12345678901234559') // the column is of REAL type and read back the value SELECT * FROM myTable then you get a value==0.12345678901234600 !! the 2 values are different. What's the problem?? Stéphane Thiers Data Systems, Lancelot

[sqlite] Error in SQLITE on applyNumericAffinity

bytes C > Sqlite.dll!sqlite3_exec(sqlite3 * db=0x0793bbf8, const char * zSql=0x07b66a88, int (void *, int, char * *, char * *)* xCallback=0x, void * pArg=0x, char * * pzErrMsg=0x04fadc50) Line 76 + 0x9 bytes C any hint ?? Thank you. Stéphane Thiers Data Systems,