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

Can I prevent use of schema in SQL

rbuserrbuser
edited August 2006 in General
Hi

I am using v10 and am getting to grips with report writing etc on an ORACLE
database

Is it possible to stop the sql generation using the schema notation i.e.

PANTEST.SUPPLIERS is the suppliers table in pantest can it use just
SUPPLIERS

The reason I ask is that it prevents the report from being used against
different schemas. The system we are building will have a live schema of
course but will also have a test and training schema with identical
structures. If I cannot surpress the use of the schema notation then is
there anyway I can write one report to run on 3 schemas.

Also, is there anyway I can change the about box in the designer. Is the
about box a requirement of the license?

regards
Andrew

Comments

  • nicociziknicocizik
    edited August 2006
    Hi Andrew,

    ReportBuilder uses the specific DADE plugin to determine the table names.
    Take a look a the GetTableNames function in the TdaSession descendent of the
    DADE plugin you are using to see how this is currently done in your case.
    You would need to change this code to alter how RB uses the tables in your
    queries.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.