Radarspotting

Can anyone tell me what the format is for deleting non Military aircraft from a sqb. file using sqlite.spy program
I want to start the new year with a .sqb file just containing my military contacts.


Any help would be appreciated.


Mike

Bit of a challenge there as I don't recall that the BaseStation .sqb file identifies military aircraft as such.

The hex codes are allocated to civil or military ranges.  Or you can use the aircraft type code.  Have you used another field to identity military?

Anmer,


From what I can remember it used the Mode S Country . In english it translated into something like "Delete where ModeSCountry not equal to *Mil


I have looked through all my notebooks in which I keedp tips and hints but cant find it'


Mike

or maybe that should be In english it translated into something like "Delete where ModeSCountry not include to *Mil
[/size]
[/size]Just I dont know the syntaxes necessary for this program.

[/size]Mike

Anmer,


Just found this in the Kinetic user forum from way back in 2012


Try this:

SELECT * [size=0pt]from[/size] Aircraft
WHERE ModeSCountry not like '%Mil';

That should list all your non Mil [size=0pt][/color]entries[/size]. You could also try:

SELECT * [size=0pt][/color]from[/size] Aircraft
WHERE ModeSCountry like '%Mil';

This should do the reverse and show all your Mil [size=0pt][/color]entries[/size]. If you are happy then run the [size=0pt][/color]Delete[/size] command instead or Select - and on a backup [size=0pt][/color]SQB[/size] first.
Just had grandchildren arrive at front door so think any playing with this will be on hold for a few hours.

Will test out at earliest convenience and report back

Regards Mike

Dont know what happened to last post but entry should read:

SELECT * from Aircraft
WHERE ModeSCountry not like '%Mil';

That should list all your non Mil entries. You could also try:

 
SELECT * from Aircraft
WHERE ModeSCountry like '%Mil';

   
This should do the reverse and show all your Mil entries. If you are happy then run the Delete command instead or Select - and on a backup SQB first.


[/size]Regards Mike

Thanks Mike.

The different forums may be using different syntax, hence the strange post from the copy text.

Make sure you backup your sqb file to a different folder before you run the sql command.