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

Reply via email to