[Kexi] decimal places

[wayne]

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