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

Login with username, password and session length
 


Author Topic: Database details  (Read 3951 times)

0 Members and 1 Guest are viewing this topic.

jmhayes

  • Jr. Member
  • **
  • Posts: 62
Database details
« 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?  :)

Allocator

  • RadarBox24.com Beta Testers
  • Hero Member
  • *
  • Posts: 3568
Re: Database details
« Reply #1 on: December 11, 2008, 07:20:07 PM »
Tarbat is the one to ask here regarding SQL searches.

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Database details
« Reply #2 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.

jmhayes

  • Jr. Member
  • **
  • Posts: 62
Re: Database details
« Reply #3 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?

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Database details
« Reply #4 on: December 11, 2008, 07:43:06 PM »
The Aircraft table in Mylog

jmhayes

  • Jr. Member
  • **
  • Posts: 62
Re: Database details
« Reply #5 on: December 11, 2008, 07:44:15 PM »
Oh, ouch.  Ok, back to the drawing board :)  Thanks.