Hello, The pda probably has no floating point support, you should check how sqlite as been compiled. Best wishes Noël
On 14 June 2013 14:19, Arjen Markus <arjen.mar...@deltares.nl> wrote: > Hi Filipe, > > > On Thu, 13 Jun 2013 15:59:35 +0100 > Filipe Madureira > <filipe.madureira@**sysdevsolutions.com<filipe.madure...@sysdevsolutions.com>> > wrote: > >> 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. >> >> > I have no solution to offer and you probably thought of it > yourseld too, but the + might be an attempt (rather > superfluous and annoying) to indicate upward rounding > took place. > > Does this happen with an ordinary C program too? The culprit > would be the printf() family as implemented on the platform. > Can scanf() read this type of numbers? > > Regards, > > Arjen > > > > DISCLAIMER: This message is intended exclusively for the addressee(s) and > may contain confidential and privileged information. If you are not the > intended recipient please notify the sender immediately and destroy this > message. Unauthorized use, disclosure or copying of this message is > strictly prohibited. > The foundation 'Stichting Deltares', which has its seat at Delft, The > Netherlands, Commercial Registration Number 41146461, is not liable in any > way whatsoever for consequences and/or damages resulting from the improper, > incomplete and untimely dispatch, receipt and/or content of this e-mail. > > > > > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > -- Noël Frankinet Strategis sprl 0478/90.92.54 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users