>
> There are many applications of multiple DBs - I agree with
> Daniel. I have worked for several (normally very large)
> corporations where there is, for example, an Accounting DB, a
> Personnel DB, a Stock DB and a Client DB (at the very least).
> It's not the same records you're storing in multiple DBs.
> Its the functionality that you HAVE to store in multiple DBs
> if you cannot talk between them.
>
> Each one of these DBs have their own metadata, with multiple
> tables and other DB objects. And it is easy to see why - it
> is very useful to be able to call (for example)
> "FINANCEDB.GETACCOUNTINGPERIOD(NOW)" (like you can in
> Sybase) from any other DB (or even a SP within a DB) in the
> system. Stock receiving, or sales, or whatever. It has many
> of the advantages of object - orientated programming : being
> able to develop and use data objects while also maintaining
> them separately.
>
> I have asked this question before (about inter - DB
> connectivity) and I believe that it cannot be done (in
> Firebird) yet. Which, in my opinion, is a pity.
>
> Regards
>
> Tim

Thank you Tim, I was starting to feel like I was in the wrong planet %-)

danieL
____________________________
Comvision Pty. Ltd.

www.comvision.net.au