AirNav Systems Forum

AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: jmhayes on December 11, 2008, 07:13:30 PM

Title: Database details
Post by: jmhayes on December 11, 2008, 07:13:30 PM

I thought I might try my hand at making a customized report generation utility, so I looked into the MyLog.db3 file and am confused.  It doesn't seem to have all the data for all the flights I've collected.  Something simple like

   SELECT * from v_Flights where ModeS='ABC123'; (fake code)

returns no rows unless that code has been seen with a non-null Callsign block?

The Reporter seems to get this right; where's the data being stored?  :)

Title: Re: Database details
Post by: Allocator on December 11, 2008, 07:20:07 PM

Tarbat is the one to ask here regarding SQL searches.

Title: Re: Database details
Post by: tarbat on December 11, 2008, 07:26:24 PM

Only aircraft with a Flight ID currently get added to the Flights table.  That's under review by Airnav as a possible future enhancement.  Flight ID is the primary key, so a Flight ID will have to be "made up" for flights that don't have a Flight ID.

Aircraft without Flight IDs do get added to the Aircraft table in MyLog.

Title: Re: Database details
Post by: jmhayes on December 11, 2008, 07:29:52 PM

Quote from: tarbat

Only aircraft with a Flight ID currently get added to the Flights table

So where does Reporter get the others from?

Title: Re: Database details
Post by: tarbat on December 11, 2008, 07:43:06 PM

The Aircraft table in Mylog

Title: Re: Database details
Post by: jmhayes on December 11, 2008, 07:44:15 PM

Oh, ouch.  Ok, back to the drawing board :)  Thanks.