![]() |
#6 |
Moderator
|
Ладно - поделюсь стратегическим знанием
![]() static void FedTest(Args _args) { Query qry; QueryRun qrun; InventTrans inventTrans1,inventTrans2; QueryBuildDataSource qbds; QueryBuildRange qbr; qry = new Query(); qbds=qry.addDataSource(tablenum(inventTrans),"it1"); qbds=qbds.addDataSource(tablenum(inventTrans),"it2"); qbds.relations(false); qbr=qbds.addRange(fieldnum(inventTrans,voucher)); qbr.value("( (it1.InventDimId != it2.InventDimId ) && (it1.inventTransId == it2.inventTransId) )"); qrun = new QueryRun(qry); qrun.reset(); while (qrun.next()) { inventTrans1 = qrun.getNo(1); inventTrans2 = qrun.getNo(2); print inventTrans1.InventTransId, " ", inventTrans1.InventDimId," ",inventTrans2.InventTransId," ",inventTrans2.inventDimId; pause; } } |
|