SQLite Expert Professional

[Magic440]

Sorry if this is posted in the wrong section.
Quick query regarding SQLite.
When i rearrange the tabs,how do i save them so they open up like when i closed the program?
Say the tabs show ModeS/Type/OpFlag etc,and i rearrange them,but when next opening the program,they have reverted back to default.
Hope that makes sense.

Regards,

Magic.

[Anmer]

What tabs do you mean?

Are you wanting to view a database's Data using SQLite Expert?

[Magic440]

I can view the Basestation sqb file,to run the command where it changes null in the Ops Flag column to the ICAO logo,but i would like the column to display on opening,instead of scrolling or dragging it into view,if that makes sense?

Magic.

[Anmer]

i would like the column to display on opening,instead of scrolling or dragging it into view,if that makes sense?

Can you post a screenshot of the view in question?

[Magic440]

The 1st pic is how i would like it to open up,instead of  the default 2nd.


Magic.

[Anmer]

Unfortunately I can zoom into those images.

Can you grab a screen capture intead of a photo?

https://techcommunity.microsoft.com/t5/windows-11/how-to-take-screenshot-on-windows-10/m-p/3760249

[Magic440]

This is how it opens as default,but i would to to change it,i can drag to columns into place,but it just reverts back to default when i next open it up.

[Anmer]

Thanks, that was a better screenshot.

You can change the current "view" of the data.  But it's only a "view".  It doesn't change the database design which you would be needed to maintain that view.  Otherwise the view reverts back to the same order when you next open the database, as you've noticed.

BUT.......

...you'd be altering the sqb structure which could cause issues as Basestation might be expecting a fixed "design".  I'm no expert in databases so this is a thought rather than a hard fact!

Are you running an sql command to change the nulls?

[Magic440]

Yes Mike,i run the command that you give me sometime ago,that fills the OpsFlag with a silhouette.

update aircraft set operatorflagcode = icaotypecode where operatorflagcode is null

[Anmer]

OK.

So you just want to view the data?

[Magic440]

Yes,but without re-arranging the column tabs if possible.

Magic.

[Faramir]

Searching for this I came on this page. Scroll down to 'A SQLite script to setup the screen' Maybe that can help?

[Magic440]

Thanks Faramar. Will have a look tommorow.
Bank Hol drinkies time soon. lol.

Magic.

[Triple7]

It's simple.

Go into the "design" tab at the top of the screen. Rearrange the columns to suit your preference, click on the "Rec No" so the row is highlighted and then use the Move up , Move down buttons on the right to adjust the position of that column in you DB. When you are happy, click "Apply" and you are done.

Next time you open the SQB in SQLite it will retain the settings. I've been using mine that way for 10+ years and never experienced an issue with any of the software packages that use the SQB file.

Have a look at this guide, whilst not specifically related to your question, it contains details on rearranging the database in the appendix.

https://radarspotting.com/forum/index.php?action=tportal;sa=download;dl=item30

[Anmer]

Go into the "design" tab at the top of the screen. Rearrange the columns to suit your preference, click on the "Rec No" so the row is highlighted and then use the Move up , Move down buttons on the right to adjust the position of that column in you DB. When you are happy, click "Apply" and you are done.

Next time you open the SQB in SQLite it will retain the settings. I've been using mine that way for 10+ years and never experienced an issue with any of the software packages that use the SQB file.

Thanks Tim.

I'd tested the Design option earlier but wasn't risking the BaseStation interface with the sqb database.

Good to know it works.