Hi,
I have a problem executing a query on a WinCE6 ARM device.
I use SQlite for years and tested on all types of devices including
WinCE6 ARM and never had a problem.
But I have one problem on particular device that has a Texas Instruments
ARM CPU with WinCE6.
A very simple way to reproduce my problem is:
Create Table t1(c1 DECIMAL(12,3))
Insert Into t1(c1) values(2.55)
Select c1 From t1
I run this "Select" with sqlite3_get_table()
The value I get is "3.,+"
It makes no sense, it is not even a number, and only happens if the
decimal values have a number higher than 5.
This seems to be a problem with this CPU/WinCE version.
I don't know SQLite source code, and it is huge, so can someone tell me
where in the source code the float (or double, I don't know) value of
2.55 is being converted to a string to be outputed by sqlite3_get_table()?
Or any hint on how to track the problem?
Note: I copied the database file to my PC and the value stored there is
2.55, so the problem is retrieving the value on the device.
--
Cumprimentos / Best Regards
Filipe Madureira
-----------------------------------------------------------------------------
SYSDEV, LDA - Mobile Solutions
(www.sysdevsolutions.com)
Tel: +351 234188027
Fax: +351 234188400
-----------------------------------------------------------------------------
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
