>> Is there a way for Firebird to return the drive letter and folder
>> where the active database is located when using aliases.conf? I need
>> to be able to access a sub-directory of the directory where the .FDB
>> is located.
>>
>> My users are allowed to select the destination drive and folder when
>> the application and database is installed.
>
> I do not know if it is possible or not, but isn't it better to store
> the location you want people to use in the database? I think it is
> more flexible...

And is there any particular reason that it has to be a subdirectory? I'm not saying that it is wrong, but I don't see why databases and files should have to be stored in a similar place (or even that all files have to be placed in the same directory). In theory, I'd say you could store the location in a separate table and that the location could vary according to each record in this table. This way you would have as much freedom as you could want (e.g. if USERNAME was one field, then the location could be different for each user, if, WEEKDAY was a field, then the location could differ according to what day it was and if PROGRAMVERSION was a field, the location could vary depending on which of your program versions that particular user was running).

You could even store the content in blob fields in the database rather than in separate files (there are pros and cons both with storing things in a database and with storing them in files).

Set