|
Что бы не быть голословной :
QueryRun exportQueryRun;
Query query = new Query();
QueryBuildDataSource qbDSb, qbDSc, qbd = query.addDataSource(tablenum(InventDim));
InventDim inv;
qbDSb = qbd.addDataSource(tablenum(PurchLine));
qbDSb.addLink(fieldNum(InventDim, InventDimId), fieldNum(PurchLine, InventDimId));
qbDSb.joinMode(JoinMode::InnerJoin);
qbDSb.fetchMode(1);
qbDSc = qbd.addDataSource(tablenum(SalesLine));
qbDSc.addLink(fieldNum(InventDim, InventDimId), fieldNum(SalesLine, InventDimId));
qbDSc.joinMode(JoinMode::InnerJoin);
qbDSc.fetchMode(1);
exportQueryRun = new QueryRun(query);
while (exportQueryRun.next())
{
inv = exportQueryRun.get(tableNum(InventDim));
print inv.inventDimId;
}
Посмотрите, что получиться
|