Gabriel said the following, On 2008-02-24 19:30: > How do I alter a table that has data in it, without losing the data? I > read that Kexi doesn't support this directly (a.o. because sqlite > doesn't support it). But what is the best way to do I this indirectly?
Please read Answer 1.8 at http://kexi-project.org/wiki/wikiview/index.php?KexiFAQ#1._General_Features > Can I somehow copy the data, alter the table (which empties it), and > then import the data in the altered table? This is the way how the scripts like ksqlite_add_column and kexi_delete_column work (just provided the links in A1.8). -- regards / pozdrawiam, Jaroslaw Staniek Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi) KDE Libraries for MS Windows (http://windows.kde.org) _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
