> --- In firebird-support@yahoogroups.com, 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
http://www.upscene.com