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

Use FB API call

isc_database_info()

and specify isc_info_db_id request.

Ivan
http://www.volny.cz/iprenosil/interbase/