Delete Message Count

Started by prbflight, August 22, 2008, 02:59:50 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

prbflight

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

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

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

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