picture field

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?

Thanks,
Wayne
Kexi 1.1.1
koffice 1.6
_______________________________________________
Kexi mailing list
Kexikde.org
https://ma
il.kde.org/mailman/listinfo/kexi

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.o
rg, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org
_______________________________________________
Kexi mailing list
Kexikde.org
https://ma
il.kde.org/mailman/listinfo/kexi

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
Kexikde.org
https://ma
il.kde.org/mailman/listinfo/kexi