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
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!
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!
Comments
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
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