Extra where clause for master detail link

Data Abstract
,
1

Is it possible to add extra where clauses for a detail table when we link master detail via where clause

Currently we use this to link
DetailTable.MasterSource:=Self.DataSource;
DetailTable.MasterMappingMode:=mmWhere;
DetailTable.MasterFields:=MasterFields;
DetailTable.DetailFields:=DetailFields;

We want to add some extra (predefined) where clauses
e.g pnm_nederlands=1 AND pnm_hoofdnaam=1

Can this be done?

2

FYI:

Already tried this but it does not appear to work
FPrijsZettingDetailJoinedTable.MasterRequestMappings.Add(fld_PrijsZettingprz_primkey+‘=’+fld_PrijsZettingDetailJoinedpzd_prz_primkey);
FPrijsZettingDetailJoinedTable.MasterRequestMappings.Add(‘pnm_nederlands=1’);
FPrijsZettingDetailJoinedTable.MasterRequestMappings.Add(‘pnm_hoofdbenaming=1’);

3

FYI: I also tried putting constants in the table.MasterFields property (comma separated) and the actual fields in the Table.DetailFields property but this fails too (constant 1 not allowed)

Help?

4

Hi Frederic,

this is a bit outside of my own scope, and unfortunately, my colleague Eugene who is best to answer this is off this week, but je gave me this suggestion>

He should apply the usual dynamic where to detail table like

Detailtable.dynamicwhere.expression := ....;

before opening table. See BinaryExpression

Also he should have {where} in his detail table.

i hope this helps?

—marc

1 Like
5

This seems to work perfectly, thanks

6

Awesome!