On 15-6-2018 20:33, Leyne, Sean wrote:
That is not within Firebird itself. I want to be able to do something like select RDB$GET_CONTEXT('SYSTEM', variable_name) from <the-table> or even select variable_name, variable_value from <the-table>Sorry, are you looking for a list of the *names* or the names *and* the values?
Yes, I'm looking for both. However, if I have a selectable source for the names, then getting the values is trivial (see my first select above, although it would have been better if I had used
select variable_name, RDB$GET_CONTEXT('SYSTEM', variable_name) as variable_value from <the-table>
Why do you feel that you need to "SELECT" that list? (I see it similar to the list of KEYWORDS -- it is not something that is SELECTable)
Because I want to be able to automatically produce a list of those values, in a preferably maintenance-free and version-independent way.
I would suggest extending MON$CONTEXT_VARIABLES, including a MON$NAME_SPACE column, and then including the SYSTEM variables.
BTW: Having a selectable source of keywords would actually be a great idea. Mark -- Mark Rotteveel ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
