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.
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).
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.
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.
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.
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
All useful info - thank you