[Kexi] picture field

wayne iw at ukulele.com
Thu Dec 7 20:14:51 CET 2006


On Thursday 07 December 2006 12:31 am, Jarosław Staniek wrote:

> wayne said the following, On 2006-12-05 19:53:
> > I want to add a picture field in my table. I can't add a new field in
> > the table or I will lose all data. I can create a new table with a
> > picture field in it but I can't figure out how to import my old data
> > into this new table. Is there any way to do this?
>
> Wayne,
> The GUI tool (Table Designer) is still in development if we talk about
> table altering. So I've just prepared a 'ksqlite_add_column' bash script
> [1] that helps this case. It basically takes care of rebuilding the
> database schema so Kexi can 'see' your new column.
>
> Type 'ksqlite_add_column' without parameters to get the list of options
> and example usage.
> The script works for me, but is of beta quality. It makes a copy of your
> database by appending ".old" suffix to the filename so you can easily
> recover in case of troubles. It's recommended to close Kexi before using
> the script.
>
> I've CC'd this info to koffice-devel as I remember that at least Cyrille
> needed to add a table column without removing the data.
>
> [1]
> http://websvn.kde.org/branches/koffice/1.6/koffice/kexi/tools/add_column
>/ksqlite_add_column

Thank you very much. The script works very well.

Wayne



More information about the Kexi mailing list