On Monday 08 January 2007 1:59 am, Jarosław Staniek wrote: > wayne said the following, On 2007-01-07 21:19: > > >>> Also, how does one determine if a floating point number is single or > >>> double precision when using the "ksqlite_add_column" script? It > >>> can't be changed once it's created. > >> > >> The default subtype of the floating-point type is double precision. > >> I'd suggest to always keep this (for current hardware it's not a > >> problem I guess). Then you'll get good precision like 12.4 is just > >> stored and displayed 12.4 and not as 12.3999996185303 (the case for > >> single-precision subtype). > > > > When I added a new column, it automatically chose single precision. I > > will delete it and try again. > > That's weird, as _you_ explicitely provide the column's type. For > example, to add a 'price' column of double precision to 'cars' table, > type: > > ./ksqlite_add_column db.kexi cars price Double
Just out of curiosity, Is there any way to safely delete a column in a table? Is there a similar script to delete a column? Thanks, Wayne _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
