Hi,

because of UDF libraries are locating on the server, I guess you could
write an UDF which parse the file aliases.conf to find the fullpath
but I think you'll have to pass the alias name to the UDF: I don't think
it could retrieve it by itself

Thierry

mohamed.banaouas a écrit :

>
> --- In firebird-support@yahoogroups.com
> <mailto:firebird-support%40yahoogroups.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
>
>