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

how to Exclude autojoin

edited June 2004 in End User
Hi,
when, in query designer, i select 2 table, it try to autojoin theese by
selecting similar fields.
there's a way to exclude this? i want user to manual join

Comments

  • edited June 2004

    What are describing is actually the manually join feature. When you select
    two tables for a query the Join dialog is displayed. The Query Designer
    attempts to be helpful by pre-selecting similar fields for the join.

    For an example of the AutoJoin feature, run RBuilder\Demos\EndUser\AutoJoin.
    This features requires use of the DataDictionary to pre-define join
    conditions. When a table is selected - for example customer, then the only
    tables that are joinable to it are available to be selected. When the second
    table is selected, for example Orders, no join dialog is displayed at all.





    --

    Thanks for supporting ReportBuilder! Please vote for ReportBuilder in the
    Delphi Informant Readers Choice awards!

    http://www.delphizine.com/ballot2004/


    Best regards,

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


  • edited June 2004

    You can create your own wizards/designers. One approach would be to copy the
    existing wizards/designers and then create your own and register them with
    RB. The DADE units are located in RBuilder\Source and are prefixed with
    'da'. You can modify your Delphi library path from RBuilder\Lib to
    RBuilder\Source and trace the source code if you want to see how it is
    currently working.


    --

    Thanks for supporting ReportBuilder! Please vote for ReportBuilder in the
    Delphi Informant Readers Choice awards!

    http://www.delphizine.com/ballot2004/


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited June 2004
    tnk
This discussion has been closed.