Subject | Joins between tables in two different databases? |
---|---|
Author | ipai1 |
Post date | 2006-04-18T04:15Z |
G'day all...
I have a requirement for a read-only database (on CD) which has tables
involved in joins to table(s) held in a read-write database somewhere
on the hard disk. My existing desktop application uses Paradox under
the BDE to do this, but I can't seem to find any way of doing this with
Firebird. Is this possible, and, if so, how would I do it? For example,
could one create views into a different database (a la SQL Server)?
I have a bit of experience with Interbase/Firebird but only in a
straightforward client/server scenario with a read/write database. I
would very much like to get away from the Paradox/BDE environment and
start using embedded Firebird ASAP, so any help would be appreciated.
Thanks in anticipation,
Alex.
I have a requirement for a read-only database (on CD) which has tables
involved in joins to table(s) held in a read-write database somewhere
on the hard disk. My existing desktop application uses Paradox under
the BDE to do this, but I can't seem to find any way of doing this with
Firebird. Is this possible, and, if so, how would I do it? For example,
could one create views into a different database (a la SQL Server)?
I have a bit of experience with Interbase/Firebird but only in a
straightforward client/server scenario with a read/write database. I
would very much like to get away from the Paradox/BDE environment and
start using embedded Firebird ASAP, so any help would be appreciated.
Thanks in anticipation,
Alex.