[Kexi] picture field

[Jarosław Staniek]

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