Data dictionary join question

rbuser

Hi,

I just started using the data dictionary for a project. I ran into the
limitation that between two tables only one join can be specified. Changing
the primary key definition didn't solve it (of course).
I have a table containing customers and a table land. The customer table
holds two land columns.
Only one can be specified in the data dictionary.

Do you know of a way to work around this?

Using D7, RB10.08, IBX

Regards,
Jeroen R?ttink

nardmoseley

One option might be to create a View for the Land table - so that you can
have a Land and a Land2 table listed in the DataDictionary and join to each
of those.

In addition you can set DataDictionary.AllowManualJoins to True to allow you
to manually specify join conditions.


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

rbuser

Thanks Nard,

The AllowManualJoins option was already in use. I'll stick with that one.
Related with this: When I once join with the land table using the query
wizard, the land table is removed from the available table list. Could the
land table stay available in the left list so I can select it a second time
for the other join relation I have and want to manual edit?

It's only an issue using the query wizard. The query designer works as
expected.

Regards,
Jeroen.

nardmoseley

The Query Designer supports linking the same table in many times. The
QueryWizard is more limited.

If you want to enable the QueryWizard to work the same way, modify
daQueryWizard.pas, the method TdaQueryWizardDialog.SetSQL as follows


procedure TdaQueryWizardDialog.SetSQL(aSQL: TdaSQL);
begin

FSQL.Assign(aSQL);

FSQL.AllowSelfJoin := True; // allow same table to be joined more than
once

end;


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