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 [email protected] https://mail.kde.org/mailman/listinfo/kexi
