AirNav RadarBox
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: Delete Message Count  (Read 3967 times)

0 Members and 1 Guest are viewing this topic.

prbflight

  • Sr. Member
  • ****
  • Posts: 328
Delete Message Count
« 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

AirNav Support

  • AirNav Systems
  • Hero Member
  • *****
  • Posts: 4127
Re: Delete Message Count
« Reply #1 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 :)
Contact Customer/Technical support via:
http://www.airnavsystems.com/contact.html
[email protected]

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Delete Message Count
« Reply #2 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!!!

prbflight

  • Sr. Member
  • ****
  • Posts: 328
Re: Delete Message Count
« Reply #3 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