Subject Firebird cross database/schema queries
Author Rick Debay
Is there a way, in 1.5, 2.0, or Vulcan, to query across databases
located on the same server?
I'm looking for something in the same vein as Oracle, e.g.

-----Original Message-----
From: Rick Debay [mailto:rdebay@...]
Sent: Tuesday, April 05, 2005 10:57 AM
Subject: RE: [firebird-support] Crystal Reports - cross database queries

Dang. Does anyone know of any Crystal resources? We're going to be
running in to this more often, and I'd really like to give Crystal
whatever hints I can to make it smarter. I don't know anything about
Crystal, I just support the folks that do. I REALLY don't want to merge
two schemas just because Crystal is brain dead.

Does it have any scripting language, so I could do something like:

[get distinct values of column N]
SELECT ID,NAME FROM SOME_TABLE_IN_DATABASE2 [attach names to results of
first select]

If there are only a few hundred distinct names, but thousands of results
from the first query, this is a good use of an application join (besides
saving me from joining dissimilar schema).

-----Original Message-----
From: Alexandre Benson Smith [mailto:iblist@...]
Sent: Monday, April 04, 2005 9:42 PM
Subject: Re: [firebird-support] Crystal Reports - cross database queries

Hi Rob,

Robert martin wrote:

>I use Crystal as well (although not for cross DB queries). My
>understanding is Crystal pretty much only applies filters on the server

>if grouping is performed. See if you cant add some grouping in and
>make sure the 'perform grouping on server option' is selected.
>Rob Martin
>Software Engineer
>phone +64 03 377 0495
>fax +64 03 377 0496
>Wild Software Ltd
The perform grouping on server is active.

The probelm I tried to show is:
Does not expect Crystal do smart things for you, you should be careful
on how to write the "Record Filters" and check how the query will be
send to the server.

I had the wrong assumption that Crystal could evaluate it before and
prepare the where clause in accordance with it, it's NOT TRUE.

Simple filters like:
{SalesOrder.SalesManID} = {?SalesManID}

will be correct transformed in a where clause like:
SalesOrder.SalesManID = <SomeValue>

the more complexes (envolving formulas, etc.) will not be sent to the
server, even it could be evaluated and choosed between some paterns.

see you !


Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 01/04/2005

Yahoo! Groups Links

Yahoo! Groups Links