AirNav Systems Forum

AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: prbflight on August 22, 2008, 02:59:50 PM

Title: Delete Message Count
Post by: prbflight on August 22, 2008, 02:59:50 PM

It's great to see the message count finally working as it should...great job AirNav. 

I imported MyLog and NavData form ANRB 2008 when I did a fresh install of ANRB 2009 and now I have both old and new messages counts showing.

Is there a way to delete old message counts from the previous version that were corrupt?

Thanks.

Paul@cyyb

Title: Re: Delete Message Count
Post by: AirNav Support on August 22, 2008, 03:06:05 PM

Not with RadarBox 2009 but you can run a SQL query on the MyLOg data to clear message count up to a certain date.

I will leave some of the other members to come up with something as its outside of our area :)

Title: Re: Delete Message Count
Post by: tarbat on August 22, 2008, 03:19:24 PM

What I did was completely empty my flights when I started using ANRB 2009, using SQL:
DELETE FROM Flights;
DELETE FROM FlightsOld;

From what I can see, the Flights table holds the latest 2000 flights, and everything else is in the FlightsOld table.

If you want to be more selective about the deletes, then open the table in something like SQLite Maestro, sort by End Time, highlight the ones you want to delete, and hit the Delete key.

Worth taking a backup before you do any of this - beware!!!

Title: Re: Delete Message Count
Post by: prbflight on August 22, 2008, 04:00:08 PM

Thanks Tarbat.

Sounds a bit out of my league so I think I will just tip-toe my way around this for awhile.


Cheers

Paul@cyyb