Welcome to Radarspotting. Please login or sign up.

May 17, 2026, 10:43:35 PM

Login with username, password and session length

New Members

New Members

You should get an activation email when you join.  If not, please use the Contact option.

BaseStation.sqb Aircraft Table Column heading

Started by rikgale, June 08, 2022, 10:29:05 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

rikgale

In a BaseStation.sqb the Aircraft table has 49 columns. Most column headings are self explanatory and I can understand there purpose.

What are the UserIBool (x5), UserInt (x5) and UserString (x5) used for?

As a VRS user I can't not see a use for them when using VRS, but I presume that they carry some function when using Basestation Software.

If anyone is able to enlighten I would be most grateful.


Auto updated daily ZIP files on GitHub

DaveReid

AFAIK, they aren't used by BaseStation either, but are available to the user (hence the column names) for any desired purpose. 

As the names suggest, they are respectively Boolean, String and Integer values (although IIRC SQLite is fairly lax about enforcing typing).

rikgale

AFAIK, they aren't used by BaseStation either, but are available to the user (hence the column names) for any desired purpose.

That was the answer I was hoping for, as I have a desired purpose, but did not want to break anything in other software.

Auto updated daily ZIP files on GitHub

Anmer

Quote from: rikgale on June 09, 2022, 08:09:52 AM
That was the answer I was hoping for, as I have a desired purpose, but did not want to break anything in other software.

Depends.  If you plan to distribute the sqb file, the use of these "spare" columns may cause issues.  We've seen this happen elsewhere.
Here to Help.

rikgale

Quote from: Anmer on June 09, 2022, 08:40:33 AM
Quote from: rikgale on June 09, 2022, 08:09:52 AM
That was the answer I was hoping for, as I have a desired purpose, but did not want to break anything in other software.

Depends.  If you plan to distribute the sqb file, the use of these "spare" columns may cause issues.  We've seen this happen elsewhere.

No current plans to distribute a .sqb file at this time, but things may change. I can always reset the columns I end up using before distributing. Forewarned is forearmed. 

Auto updated daily ZIP files on GitHub

Roadrunner

Rick,

If you use PlaneBase the UserStrings are used to separet gorups of aircraft B J G H P M etc mainly 4 & 5.

also Kelvin Cross's great Mode-S Tweaker has them available on his program

Regards

Mike

rikgale


Auto updated daily ZIP files on GitHub