1000 up

[Squad 701]

Hi Glyn,
Your officially an A-Lister now.
You passed the 2500 mark by 16.
I bow my hat to you :-)
Your the Man.

Have to agree with you on the Midnight UTC thing,
very annoying, roll on version 2.1

[John Racars]

Hi All,

Here the results of my 24 hrs listening yesterday, may 31th. I do not believe this numbers are reliable. This because the "strange" reporting of "My Log":

yesterdays intermediate scores:

09:38 - 1197 Aircraft Logged;
18:20 - 2747 Aircraft Logged;
18:38 - 2769 Aircraft Logged;
23:11 - 2886 Aircraft Logged;

Now when I get the total report of yesterday "My Log" says:

2092 Aircraft Logged. Unbelievable.

I think there is for the time being no sense to make reports like this any more; it should be made better in next coming version(s).

[AirNav Support]

John,

This has been explained dozens of times now. Please read our message earlier in this thread regarding it.

[John Racars]

This has been explained dozens of times now. Please read our message earlier in this thread regarding it.

OK Support, thank you and verry sorry for the inconvenience,

I will do as you recommend in this message (using the SQLite software):

http://www.airnavsystems.com/forum/index.php?topic=2395.msg20129#msg20129

[John Racars]

Hi All,

Now I have analysed "MyLog" > "Flights"-database with the beautiful SQLite software. This becomes an impressiv new number of logs.

I filtered out the records of yesterday that gives this result:

Sunday, may 31th 2009 from 00:00 - 23:59 UTC: 4273 Aircraft Logged.

If you are interested in the list, please let me know and I will sent it to you.

[John Racars]

Hi Support,

Any chance that "Aircrafttype" will displayed in the "MyLog" > "Flights" table in the next new coming version(s) as well?

[tarbat]

John,

Aircrafttype is in the Aircraft table, so just do a " LEFT OUTER JOIN Aircraft ON (Flights.ModeS=Aircraft.ModeS)" to join the tables, and you can then pull data from the Aircraft table as well.

[John Racars]

Thank you Tarbat!

I will give it a try the next coming hours!

[John Racars]

Aircrafttype is in the Aircraft table, so just do a " LEFT OUTER JOIN Aircraft ON (Flights.ModeS=Aircraft.ModeS)" to join the tables, and you can then pull data from the Aircraft table as well.

Hi Tarbat,

I did not have any succes with this until sofar. Can you, or some other SQL specialist, give me the SQLite syntaxes for this routine?

Thank you in advance!

[tarbat]

SELECT 
  Flights.Route,
  Flights.Callsign,
  Flights.EndTime,
  Flights.ModeS,
  Flights.MsgCount,
  Flights.Registration,
  Flights.Session,
  Flights.StartTime,
  Flights.StartPosition,
  Flights.EndPosition,
  Flights.StartAltitude,
  Flights.EndAltitude,
  Flights.StartGS,
  Flights.EndGS,
  Aircraft.Comment,
  Aircraft.LastTime,
  Aircraft.FirstTime,
  Aircraft.AircraftTypeLong,
  Aircraft.AircraftTypeSmall,
  Aircraft.Airline,
  Aircraft.ModeS,
  Aircraft.ModeSCountry,
  Aircraft.Registration,
  Aircraft.ADSB
FROM
 Flights
 LEFT OUTER JOIN Aircraft ON (Flights.ModeS=Aircraft.ModeS)

[John Racars]

Thank you verry much Tarbat!

No succes yet: SQL Error: near "LEFT": syntax error

[tarbat]

Strange, works okay for me.

Can you post the SQL you're using.

[John Racars]

Can you post the SQL you're using.

I am using SQLiteMaestro version 8.11.0.1

[malc41]

Shouldn't make any difference that is what I use as well?

[tarbat]

I am using SQLiteMaestro version 8.11.0.1

Okay, I also use SQLite Maestro.   Query should look something like this in Maestro.

Post the SQL you're using, and we can maybe see what's going wrong for you.