[Kexi] how to alter table and keep data

[Jarosław Staniek]

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)