Subject Re: [firebird-support] using multiple databases
Author Daniel Rail
Hi,

At February 26, 2005, 13:28, Ann W. Harrison wrote:

> Actually, GDML does use database aliases, and can use different
> databases in nested statements, like this:

> FOR X IN DB1.table1
> BEGIN
> FOR Y DB2.table1 WITH Y.field1 = X.field1
> BEGIN
> <do whatever to either table>
> END
> END

> What it doesn't do is real joins. The problem isn't aliases, which is
> easy, but query decomposition and optimization.

For me aliases was just the tip of the iceberg. I know that there's
more than meets the eye in implementing cross-database support. At
the moment, I would prefer that the developement focus be on releasing
FB 2.0 and then merging of FB 2.0 and Vulcan to release FB 3.0. Then
maybe this feature could be tackled for FB 4.0. Unless someone
contributes the money to have it implemented in FB 3.0.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)