[Kexi] Re: How to add a column to table in Kexi 1.1.3?

[Swarup]

Hi, Anne,
Thank you so much for your kind suggestions :). 
Unfortunately, I am not knowledgeable on those technical aspects you
mentioned, and would not be able to execute the 1st, 2nd, and 4th steps
without completely step-by-step, explicit instructions.

Let us see what JS has to suggest-- perhaps there is an easier way.

I too use Ubuntu, and the version of Kexi I have now is the one that
comes with the Ubuntu I am using. There is a new Ubuntu version coming
out in April I believe, and perhaps Kexi 2.x available for it.

Thanks again,
Swarup 


On Thu, 2011-03-24 at 09:56 +0200, Anne Wainwright wrote:
> Hi, Swarup,
> 
> 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
> postgreql.
> 
> 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
> 
> Anne
> 
> Swarup from dinbandhu at sprynet.com said on Thursday 24 March 2011:
> 
> > Hello,
> > 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?
> > 
> > Thanks!
> > Swarup 
> > 
> > _______________________________________________
> > Kexi mailing list
> > Kexi at kde.org
> > https://mail.kde.org/mailman/listinfo/kexi
> 
> _______________________________________________
> Kexi mailing list
> Kexi at kde.org
> https://mail.kde.org/mailman/listinfo/kexi