Re: Purging old Calendar items

If you know the URNs for the events you want to delete, you can write a
small script to generate SQL like

DELETE FROM calendar WHERE urn=5;
DELETE FROM calendar_urn WHERE urn=5;

for each one, then just pipe that into sqlite.

p.

On Fri, 2003-04-11 at 20:22, Rene Castberg wrote:
> Thanks, i take it i would just have to delete the lines belonging to
>
> INSERT INTO calendar VALUES(5,'....',0);
> ....
> ....
> ....
> INSERT INTO calendar_urn VALUES(5);
>
> and then reimport the dump. I'm assuming this would be the easiest way
> to remove the appointments, rather than go through and delete them one
> bye on.
>
> Rene
>
> On Fri, 2003-04-11 at 16:10, Joseph J. McCarthy wrote:
> > not right now, but this would be a good thing to add....
> >
> > On Thu, 2003-04-10 at 06:58, Rene Castberg wrote:
> > > Hi, is it possible to purge all the old calendar items?
> > >
> > > Its taking quite a while for the calendar app to open right now. I had a
> > > look at the calendar data file with sqlite and i had alot of old data.
> > > Is there a simple way to delete this?
> > >
> > > Rene
> > >
> > > _______________________________________________
> > > GPE mailing list
> > > GPE@handhelds.org
> > > https://handhelds.org/mailman/listinfo/gpe
>
> _______________________________________________
> GPE mailing list
> GPE@handhelds.org
> https://handhelds.org/mailman/listinfo/gpe
>
Received on Fri Apr 11 18:34:29 2003