[Kexi] Re: How to add a column to table in Kexi 1.1.3?
anotheranne at fables.co.za
Thu Mar 24 08:56:16 CET 2011
The procedure that I have used is to:
1. export the data direct* from the database in a delimited format
2. create & run a script (say, perl) to add an extra delimiter at the
end of each record so extracted
3. use kexi to add in the new field (thus losing the data as you note)
4. import the modified delimited data direct* into the modified database
don't try to add the field direct into the database, kexi won't like
that and you may run into permissions issues.
best of luck. You should probably upgrade to kexi 2.x but I haven't
myself as does not seem available on ubuntu yet (I may be wrong now but
last time I looked it wasn't).
if your new field is boolean you may also have issues if running
If JS suggests any other solution, trust him and not me. It might not
be as simple as I suggest, long time since we did this.
* direct. via the database's own sql commands, not though kexi.
hope this helps
Swarup from dinbandhu at sprynet.com said on Thursday 24 March 2011:
> I am using Kexi 1.1.3 (KOffice 1.6.3), and need to add a column to a
> table which I have been using for a few years. I have experimented in
> the past with adding columns, and found that when I do so, I lose all
> the data in the table. What I had done was to go into design view and
> type in another column header there-- which does add a column, but
> also causes destruction of all the data in the table. What is the
> technique for adding a column, such that one does not thereby lose
> the data in the table?
> Kexi mailing list
> Kexi at kde.org
More information about the Kexi