| Subject | Re: [firebird-support] Attaching to more then one DB at a time |
|---|---|
| Author | Helen Borrie |
| Post date | 2011-01-18T06:39:57Z |
At 05:02 PM 18/01/2011, samcarleton wrote:
./heLen
>I am working on a program that is currently using SQLite. One of its features is the ability to attach to a second DB file. This is am important concept in my application because I have one DB for the general system and another for a specific 'document'.Simply make an attachment to another database (as many as you want), in the same way you're doing it for your "first" attachment. You can also run a single transaction across multiple attachments, such that a consistent view of data state in all the databases is maintained whilst the transaction is active.
>
>The system does NOT do any multi-database or cross-database queries, the system just does a SELECT ... FROM system.<table> or a SELECT ... FROM doc.<table>.
>
>Is there some type of attach commend or something that can be used once you are already connected to a DB to allow this behavior?
./heLen