UDF returning database file path

Mohamed Banaouas wrote:

Is there any udf (or internal function) to get database file fullpath? for example: `C:MYFOLDERMYBASE.FDB`. It could be usefull to verify the base we are connected to, especially when an alias is specified during connect step.

Thomas Steinmaurer answers:

1. if you are using Firebird 2, and
2. if you don't have DatabaseAccess = None set in firebird.conf

then the following SQL statement will give you the full path:

select rdb$get_context('SYSTEM', 'DB_NAME') from rdb$database

Ivan Prenosil adds:

For older Firebird version, use isc_database_info() Fb API call and specify isc_info_db_id request.