Using Data Dictionary Joins to select multiple tables in querybuilder

rbuser

Hello there,

I have a user who is constructing a query for a new report which includes a
number of database tables - using joins from the data dictionary table. He
is complaining that reportbuilder is not using the right join (it is joining
using a link to another table which he has already joined to within that
query). Is there anyway that an end user can infuence the join which
reportbuilder chooses to use when joining a new table to a in the
querybuilder?
Thanks,


Nick

--
Nick White
FDS Advanced Systems
Tel: 01483 481024
Fax: 01483 486956

nardmoseley

Set TppDataDictionary.AllowManualJoins to True.

From the RBuilder.hlp file.....

Declaration

property AllowManualJoins: Boolean;

Description

This property only applies when the AutoJoin property has been set to True.
If AllowManualJoins is False, then the relations defined in the rbJoin data
dictionary table represent the only legal joins between tables. When using
the Query Wizard and Query Designer the end-user will only be able to join
tables which have a predefined relationship in the AutoJoin table. If
AllowManualJoins is set to True, the end-user can modify any join
relationship which was created based on an entry in the AutoJoins table and
can also create new relations (join conditions) between tables which have no
predefined relation.

--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

rbuser

Thanks Nard - Very helpful and much appreciated.

--
Nick White
FDS Advanced Systems
Tel: 01483 481024
Fax: 01483 486956