Home› End User
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Multiple alias

rbuserrbuser
edited February 2004 in End User
Hi!

I'm working on an application which opens queries on multiple BDA alias.
Sometimes, even joins are made between those alias. In those cases I do not
specify the DATABASENAME property of the TQuery component and the SQL query
is build this way :

SELECT SOMEDATA
FROM ":ALIAS1:TABLE1" A
INNER JOIN ":ALIAS2:TABLE2" B
ON A.ID = B.ID

This always worked fine for me.

The thing is that the app has an End-User Report Designer which uses Data
Dictionaries. How do I build my dictionaries using those multiple BDE alias
?

Thanks!

Comments

  • nardmoseleynardmoseley
    edited February 2004

    The query tools in ReportBuilder do not support building queries for
    multiple aliases. All of the tables must reside in the same alias.


    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.