--- 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 ?
thanks