Thanks for the reply Richard... I"ll try this !
-Sandeep
[EMAIL PROTECTED] wrote:
Sandeep Suresh <[EMAIL PROTECTED]> wrote:
Hi all,
The problem is for one of the columns that have values ( 8209454,
1254234, 1245663 ) in db_old, the values in the new database are changed
to ( 8209454.0000001, 1254234.0000001 , 1245663.0000001 ). This column
is not defined as 'primary key' or integer.
I'm using version 2.8.14 and the weird thing is there is no problem when
I use LiteQuery which uses 2.8.12. That means, there is no problem with
my query. I also checked with version 2.8.17 and the problem still
exists. And yeah, at this time I'm not in a position to switch to
version 3.
Is this a known isssue with sqlite version 2 ? Does anyone know what's
happening ?
This is not an issue known to me. I do not know what is happening.
Try using round() on the values.
--
D. Richard Hipp <[EMAIL PROTECTED]>