Deleting Mode-S codes

[AlanT]

Gents

Is there any way of deleting mode-s codes en-block for redundant airframes, thinking of the likes of RAF Harriers, tornadoeos, tristars etc etc, rather than have to felete each one individually.

I do not have much computer knowledge so anything technical is probably out of my comfort zone.

Thanks
Alan

[reheat101]

Morning Alan,

Sounds like you have a pretty old SQB there ?,

I'm pretty sure you cannot do a bulk delete of mode-s code's in Basestation Reporter, or any other populating software, I could be wrong,
maybe check out Planebase.biz,

Why not start fresh with s92driver's SQB which you can download from here along with corresponding operator logos.

Regards,

Lee.

[Anmer]

SBS-1 Populate has the option to bulk delete aircraft types.

Alternatively you can use an SQL editor such as SQLite Expert Personal.  SBS-1 Populate looks to be the easier option which you can download using the link in this post:

https://radarspotting.com/forum/index.php?topic=12732.msg52335#msg52335:



[attachment deleted reduce file load]

[egnx]

Be aware that you can only remove a mode-s code that doesn't have any existing associated Flights in the BaseStation.sqb

So if the mode-s you want to delete has associated flights those have to be removed from the Flights table first before the Aircraft record can be deleted.

I don't know what the SBS-1 Populate does in these circumstances ?

egnx

[Anmer]

I don't know what the SBS-1 Populate does in these circumstances ?

It deletes the associated sessions too.

Just, successfully, deleted all TOR types.

[attachment deleted reduce file load]

[AlanT]

Thanks gents will give SBS-1 Populate a try

Alan