Search code examples
c++delphifirebird

Ways to determine the version of Firebird SQL?

Is there any way to determine which version of Firebird SQL is running? Using SQL or code (Delphi, C++).

Solution

  • If you want to find it via SQL you can use get_context to find the engine version it with the following:

    SELECT rdb$get_context('SYSTEM', 'ENGINE_VERSION') 
             as version from rdb$database;

    you can read more about it here firebird faq, but it requires Firebird 2.1 I believe.