[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kexi
Subject:    Re: [Kexi] picture field
From:       wayne <iw () ukulele ! com>
Date:       2006-12-07 19:14:51
Message-ID: 200612070914.51726.iw () ukulele ! com
[Download RAW message or body]

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
_______________________________________________
Kexi mailing list
Kexi@kde.org
https://mail.kde.org/mailman/listinfo/kexi

[prev in list] [next in list] [prev in thread] [next in thread]