Silhouttes in Operator Logo column

[Magic440]

Just wondering, if there is a easier way than manually editing the ICAO code,to get the silhouttes to show,where the operator logo is missing.
I'm updating the database by using ADU software.
Thanks.

David.

[Anmer]

If you want to see a type silhouette in the BaseStation aircraft list, the type has to populate the Operator Flag Code field in the Basestation.sqb.

The aircraft list isn't able to display a logo and a silhouette, just one or the other.

You could use SQL to "batch" populate empty Operator Flag Code fields with the ICAO Type Code, assuming that field is already populated for the aircraft record(s).

[Magic440]

That's exactly what I'm after Mike. Unfortunately,i'm not familiar with SQL,and wouldn't know where to start re a command. Lol

David.

[Anmer]

I think this should do it but please make a copy of the sqb file for backup before running the SQL

Code Select Expand

update aircraft set operatorflagcode = icaotypecode where operatorflagcode is null

[Magic440]

I have SQLite downloaded,and backed up the SQB file.
No idea what to do now.lol

David.

[Anmer]

No idea what to do now.lol

In SQLIte, open the relevant database:

File->Open Database

Then select the SQL tab and paste the command followed by "Execute SQL"

[attachment deleted reduce file load]

[Magic440]

Thank you Mike.
All is good.

David.