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 -- regards / pozdrawiam, Jaroslaw Staniek Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on Kexi & KOffice: http://www.kexi-project.org, http://www.koffice.org KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
