SQL program recommendations?

[John Racars]

My MyLog.db3 is okay.  What's the problem?

Hi Tarbat,

I am verry sorry but with me it is not okay. I send you (and Support as well) a report in the past. So I think you (and Support) knows the problems I reported. If you read the reports I send to you careful you must see what I mean??????????????? Am I the only one in the world of ANRB-users have this problems?

I see much doubling lines of flights; flight with wrong route information, flights with NO route information while there is information in the local database....It is a big  heap of ruins when a make a querie........

I reported this to Support and they told me the problem is known and should be solved....

[tarbat]

I see much doubling lines of flights

Yes, I get this, but usually caused by an aircraft changing it's FlightID many times.  See VT-ESO in my log from yesterday.  It correctly shows that the aircraft cycled through many Flight IDs, so not an error in my opinion.
http://www.tarbat.gofreeserve.com/data.html

flight with wrong route information

Yes, sometimes the route lookup is wrong.  That's not a problem with MyLog, more a problem with the route lookup service that ANRB uses.

flights with NO route information while there is information in the local database

Not seen this, but may be caused by transition from network to local flight - something Airnav have said will be investigated.

[John Racars]

OK Tarbat, thank you for your explanation.

The crux:

Why did I not see all this phenomena in version 2? Reports I made there with the help of SQLite Maestro looks allways verry clean......

And, I have switched off the network most of the time (because I have more then enough with the receptions with my own setup).