Ways to Determine the Version of Firebird SQL?

Question

Exist any Way to Determine the Version of Firebird SQL is running? using SQL or code (delphi, C++).

Bye

Answer 1

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.

Answer 2

Two things you can do:

• Use the Services API to query the server version, the call is isc_service_query() with the isc_info_svc_server_version parameter. Your preferred Delphi component set should surface a method to wrap this API.
  For C++ there is for example IBPP which has IBPP::Service::GetVersion() to return the version string.
  What you get back with these is the same string that is shown in the control panel applet.

• If you need to check whether certain features are available it may be enough (or even better) to execute statements against the system tables to check whether a given system relation or some field in that relation is available. If the ODS of the database is from an older version some features may not be supported, even though the server version is recent enough.
  The ODS version can also be queried via the API, use the isc_database_info() call.