I understand, thanks a lot Jean-Christophe Deschamps wrote: > 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 >
-- Riccardo Cohen Architecte du Logiciel http://www.architectedulogiciel.fr +33 (0)6.09.83.64.49 Membre du réseau http://www.reflexe-conseil-centre.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users