[Koha] Updating database

[Lewis Satini]

I am sorry my explaination is not clear,
I think i can give you an example.
so first i have input about 20 data in the databases system, but them after 
that I realize that there's table that I need to link to another table like 
the 942k that need to be link to the biblioitems.classification so that it 
will shows up. so I do the update, but the past data that was previously key 
in won't update, won't shows up. I have to delete the data then reentry 
again, then it will shows up.
I hope this will explain well

thanks for your help


>From: "James Weinheimer" <j.weinheimer at aur.edu>
>To: "'MJ Ray'" 
><mjr at phonecoop.coop>,<andylou17 at hotmail.com>,<koha at lists.katipo.co.nz>
>Subject: RE: [Koha] Updating database
>Date: Tue, 9 May 2006 12:57:52 +0200
>
>Actually, if I understand this question, it's one that I would also like to
>know the answer:
>
>Is there a way of overwriting a record already in the database (not in the
>MARC reservoir)? This would be a very nice function which could allow for
>the creation of "temporary" or "preliminary" records that could then be
>overwritten by another record downloaded from another library. Of course, 
>we
>would need to retain acquisitions and circulation information. There could
>be various levels of control in this, too (e.g. overwrite certain fields 
>but
>not others).
>
>Thanks,
>Jim
>
>James Weinheimer  j.weinheimer at aur.edu
>Director of Library and Information Services
>The American University of Rome
>via Pietro Roselli, 4
>00153 Rome, Italy
>voice- 011 39 06 58330919 ext. 327
>fax-011 39 06 58330992
>
> > -----Original Message-----
> > From: koha-bounces at lists.katipo.co.nz [mailto:koha-
> > bounces at lists.katipo.co.nz] On Behalf Of MJ Ray
> > Sent: Tuesday, May 09, 2006 12:31 PM
> > To: andylou17 at hotmail.com; koha at lists.katipo.co.nz
> > Subject: Re: [Koha] Updating database
> >
> > "Lewis Satini" <andylou17 at hotmail.com>
> > > is there away to update my database, I mean there's record that I 
>delete
> > and
> > > when i check my database deleted tables it shows that the data still
> > exists,
> >
> > You can edit the database with phpmyadmin or similar tools, but
> > take a backup first in case it breaks.
> >
> > > is there anyway to update all the database, so that all the data in 
>the
> > past
> > > will be update too.
> >
> > I'm not sure what you're asking for.
> >
> > Hope that helps,
> > --
> > MJ Ray - personal email, see http://mjr.towers.org.uk/email.html
> > Work: http://www.ttllp.co.uk/  irc.oftc.net/slef  Jabber/SIP ask
> >
> > _______________________________________________
> > Koha mailing list
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
>
>

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/