NoExistsJoin и addRange

[raz]

qbds = query.addDataSource(tableNum(VendInvoiceJour));
qbds.addRange(fieldnum(VendInvoiceJour, InvoiceDate)).value(QueryRange('2011/03/01','2011/03/20'));
qbds.addRange(fieldnum(VendInvoiceJour, CENTERPROFIX)).value(QueryValue('008-001'));

qbds = qbds.addDataSource(tableNum(VendInvoiceTrans));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(VendInvoiceJour, PurchId), fieldnum(VendInvoiceTrans, PurchId));

qbds = qbds.addDataSource(tableNum(PurchTable));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(VendInvoiceJour, PurchId), fieldnum(PurchTable, PurchId));

qbds = qbds.addDataSource(tableNum(PurchLine));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(PurchTable, PurchId), fieldnum(PurchLine, PurchId));

qbds = qbds.addDataSource(tableNum(VSN_PURCHORDERJOUR));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(PurchLine, VSN_PURCHORDERID), fieldnum(VSN_PURCHORDERJOUR, ORDERID));
qbds.addRange(fieldnum(VSN_PURCHORDERJOUR, CENTERPROFIX)).value(QueryValue('008-001'));


// правильнее

qbds = query.addDataSource(tableNum(VendInvoiceJour));
qbds.addRange(fieldnum(VendInvoiceJour, InvoiceDate)).value(QueryRange('2011/03/01','2011/03/20'));
qbds.addRange(fieldnum(VendInvoiceJour, CENTERPROFIX)).value(QueryValue('008-001'));

qbds = qbds.addDataSource(tableNum(VendInvoiceTrans));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(VendInvoiceJour, PurchId), fieldnum(VendInvoiceTrans, PurchId));
qbds.addLink(fieldnum(VendInvoiceJour, PurchId), fieldnum(VendInvoiceTrans, PurchId));
qbds.addLink(fieldnum(VendInvoiceJour, InvoiceId), fieldnum(VendInvoiceTrans, InvoiceId));
qbds.addLink(fieldnum(VendInvoiceJour, InvoiceDate), fieldnum(VendInvoiceTrans, InvoiceDate));
qbds.addLink(fieldnum(VendInvoiceJour, numberSequenceGroup), fieldnum(VendInvoiceTrans, numberSequenceGroup));
qbds.addLink(fieldnum(VendInvoiceJour, InternalInvoiceId), fieldnum(VendInvoiceTrans, InternalInvoiceId));

qbds = qbds.addDataSource(tableNum(PurchLine));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(VendInvoiceTrans, InventTransId), fieldnum(PurchLine, InventTransId));

qbds = qbds.addDataSource(tableNum(VSN_PURCHORDERJOUR));
qbds.relations(false);
qbds.joinMode(joinMode::InnerJoin);
qbds.addLink(fieldnum(PurchLine, VSN_PURCHORDERID), fieldnum(VSN_PURCHORDERJOUR, ORDERID));
qbds.addRange(fieldnum(VSN_PURCHORDERJOUR, CENTERPROFIX)).value(QueryValue('008-001'));