Subject Re: [firebird-support] Re: udf returning database file path
Author Thomas Steinmaurer
> --- In, Thomas Steinmaurer <ts@...>
> wrote:
>>> Is there any udf (or internal function) to get database file fullpath?
>>> for example: C:\MYFOLDER\MYBASE.FDB.
>>> It could be usefull to verify the base we are connected to, especially
>>> when an alias is specified during connect step.
>> - if you are using Firebird 2, and
>> - 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
> And for older versions, no way ?

I'm not aware of an UDF which is doing that.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions