Flight Number Query

[bearcat]

Hi Tarbat

Just been playing with your SQL script and it works very well. Hope you don't mind if it is used to produce reports for Yahoo groups from time to time.

Thanks

Bearcat

[Jollygreen]

Tarbat.. having got home I looked at MyLog and found that the duplicate records have the same MsgCount, albeit on two separate days. Maybe this is why I am seeing duplicates. I have attached a screeen shot of MyLog so you can see what I mean.

Has anyone else noticed this in MyLog when sorted by EndTime

Nigel

[ACW367]

As I use mylog reporter solely for the purpose of producing logs on the mode S yahoo group.  I am not interested in routing history being stored in mylog.  I post to Yahoo purely to take advantage of the Parser service and to show aircraft that were airborne on that day, rather than to be completely accurate will all flights tracked for specific aircraft over a day.

What I do before asking for the reporter log is to look what time that I recieved the very first aircraft on the day in question, then I set the 'delete old data' tab to a time 20 mins before this.  This deletes the flight details for previous days without removing the aircraft record or todays flights from my logs.  Of course it means in the log it only shows the first flight you track for that aircraft on the day in question, but it means that you are not displaying historic routes flown on previous days in your reporter.

[tarbat]

Tarbat.. having got home I looked at MyLog and found that the duplicate records have the same MsgCount, albeit on two separate days.

Yes, that's a known issue, discussed on various threads last year - http://www.airnavsystems.com/forum/index.php?topic=1218.msg9080#msg9080.  Possibly caused by the PC going into standby, or some other reason for the reception of an aircraft being interupted.

That's why I use my SQL scripts for reporting, so I don't get those duplicates.