![]() |
#7 |
Участник
|
Вот такого плана:
<div class='XPPtop'>X++</div><div class='XPP'> qu =[color=:blue]new[/color] Query(); qbds_R = qu.addDataSource([color=:blue]tablenum[/color](Table_1)); qbds_R.addRange([color=:blue]fieldnum[/color](Table_1,BooleanField)).value([color=:red]"1"[/color]); qbds_I = qbds_R.addDataSource([color=:blue]tableNum[/color](Table_2)); qbds_I.addLink([color=:blue]fieldnum[/color](Table_1, IdField), [color=:blue]fieldnum[/color](Table_2, IdField)); qbds_I.addRange([color=:blue]fieldnum[/color](Table_2, Direction)).value([color=:red]"1"[/color]); qbds_I.addRange([color=:blue]fieldnum[/color](Table_2, StatusReceipt)).value([color=:red]"!1,!2"[/color]); qbds_I.joinMode(JoinMode::NoExistsJoin); this.query(qu); this.executeQuery();</div> |
|