|
legerJournalTransDS = legerJournalTableDS.addDataSource(tablenum(LedgerJournalTrans),'a');
legerJournalTransDS.relations(true);
legerJournalTransDS.addRange(fieldnum(LedgerJournalTrans,TransDate));
legerJournalTransDS1 = legerJournalTransDS.addDataSource(tablenum(ledgerJournalTrans),'b');
legerJournalTransDS1.joinMode(joinMode::NoExistsJoin);
qbr = legerJournalTransDS1.addRange(fieldnum(LedgerJournalTrans,recId));
qbr.value( strfmt('(%1.%2 < %3.%4)',
legerJournalTransDS.name(),
fieldId2name(tableNum(ledgerJournalTrans),fieldnum(ledgerJournalTrans,recId)),
legerJournalTransDS1.name(),
fieldId2name(tableNum(ledgerJournalTrans),fieldnum(ledgerJournalTrans,recId))
));
|