|Subject||Re: [firebird-support] udf returning database file path|
> Is there any udf (or internal function) to get database file fullpath?- if you are using Firebird 2, and
> 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 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
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and