Ricardo,
>I have typeof(basket)=real in all records ...
>I just see now that all data are float numbers in the text file that was
>used for inserting rows, and did not notice this because SqliteExpert
>show only ints !
SQLite Expert (which I use extensively in the Pro version) enforces
displaying types as declared. So if you declare your column as INTEGER
(or INT, ...) then it will display integers regardless of the actual
individual data type using common conversions. This is a side effect
of the Delphi grid component that Bogdan uses.
I see that as a unevitable drawback of SQLite flexibility about
types. A generic tool like Expert needs to stick to some set of rules
about types, which isn't the case for an ad hoc application, where you
have full lattitude to manage varied types inside a column and apply
complex processing/display rules, possibly far beyond what SQL would allow.
--
Jean-Christophe Deschamps
eMail: <mailto:j...@q-e-d.org>j...@q-e-d.org
SnailsTo: 1308, route du Vicot
40230 Saint Jean de Marsacq
France
GSM: +33 (0)6 15 10 19 29
Home: +33 (0)5 58 77 71 79
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
