Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Alias names

edited February 2004 in End User

Using Query Designer, sometimes the table names are showed, instead of
it?s alias names. Like:

Table name Alias

TPRD Products


Does anyone can help?


Marcelo

Comments

  • edited February 2004

    When a new query dataview is created, the Designer.DataSettings are saved
    with the dataview as part of the definition. In an end-user application,
    you will want to have all dataviews created with the same DataSettings. If
    you have some dataviews that were created with different DataSettings, then
    try using the Report.Template.OnLoadEnd event to update them.

    ReportBuilder caches information about the tables and aliases. If you load
    some reports that use the DataDictionary and some that do not, then the
    cache will contain a mix of information that is confusing when creating new
    reports.

    You can clear the meta data cache as follows:

    ----------------------------------------
    Tech Tip: Clearing the Meta Data Cache
    ----------------------------------------

    There is a global meta data cache that the ReportBuilder uses to cache
    information about the available database tables and fields. You can clear
    the meta data cache using the following code.

    uses
    daMetaDataManager;

    begin
    gMetaDataManager.Clear;

    end;

    --
    Tech Support mailto:support@digital-metaphors.com
    Digital Metaphors http://www.digital-metaphors.com




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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited February 2004



    ---
    Outgoing mail is certified Virus Free.
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.592 / Virus Database: 375 - Release Date: 18/02/2004
  • edited February 2004
    sorry

    in what event this method should be used?

    "gMetaDataManager.Clear"


    Marcelo




This discussion has been closed.