BaseStation.sqb file question

[SoCal Mac]

Running VRS with database writer & editor plugins. I use Mode S Tweaker to view the basestation file.
Is there anyway to print the data I see in the format Mose S Tweaker shows. I can also use the report function in VRS to modify the basestation file but no print feature.

I would like to call up P-8A data and print it out. Not sure if possible to do printouts on sqb type files.

Thanks,

Mac

[Anmer]

Is there anyway to print the data I see in the format Mose S Tweaker shows. I can also use the report function in VRS to modify the basestation file but no print feature.

I don't think you can achive this using BaseStation Reporter or Mode S Tweaker.

But you could use an SQL database editor such as SQLite Expert Personal (free to use) to run an SQL query on the ICAOTypeCode.  Then copy the results and paste into Excel or another application.

I just tested this using this Query (on a small test SQB file):

Code Select Expand

SELECT*
FROM Aircraft
WHERE ICAOTypeCode = 'P38'
Then right mouse clicked in the Results window and chose "Copy Records".  Then pasted in a blank Excel workbook.

[SoCal Mac]

Many thanks. I'll give that a try.

Mac

[SoCal Mac]

Gave it a try and got what I was looking for.   

Thanks Mike.

[Anmer]

Great.  Some powerful tools in the SQLite Expert Personal edition when using SQL queries.

[SoCal Mac]

First time using it. Your instructions let me get the info I was looking for. Will see what else I might use it for. I was looking for a P-8A data list since I get so many flights. So far I have 229 different hex codes for United States P-8A's. Around 100 must be tactical hex codes.

Next will be the KC-135's want to see how many I've seen so far.

Many thank again.

Mac,