Показать сообщение отдельно
Старый 26.09.2005, 18:23   #6  
yooshi is offline
yooshi
Участник
 
48 / 10 (1) +
Регистрация: 26.05.2005
query = new Query();
query.addDataSource(tablenum(InventTrans), "InventTrans");
...
query.dataSourceTable(tablenum(InventTrans)).addDataSource(tablenum(InventTransPosting), "InventTransPosting");

query.dataSourceTable(tablenum(InventTransPosting)).
addLink(fieldnum(InventTrans, InventTransId), fieldnum(InventTransPosting, InventTransId));

query.dataSourceTable(tablenum(InventTransPosting)).addRange(fieldnum(InventTransPosting, InventTransPostingType)).
value(queryValue(InventTransPostingType::Financial));

query.dataSourceTable(tablenum(InventTransPosting)).addRange(fieldnum(InventTransPosting, ItemId)).
value(queryValue(_itemId));
...
while (qr.next())
{
inventTrans = qr.get(tablenum(InventTrans));
inventTransPosting = qr.getNo(2);
}