Implement a Query with Join

BIZ TMS Aurelius
2
Hello Flavio,

You can simply create a class TMovimentDetail with an association to TMovimentMaster:


TMovimentDetail = class
  FMaster: TMovimentMaster;

then do a search on MovimentDetail using your criteria:


Details := Manager.Find<TMovimentDetail>.
  Where(Linq[‘descrizione’]  = ‘TEST’ or Linq[‘descrizione’].IsNull)

Then you can get the master using the association:


for Detail in Details do
  Detail.Master // use master here