private void initQuery(Contractclass _contract)
{
query = _contract.getQuery();
wmsQBDS = query.dataSourceTable(tableNum(inventtable));
QueryBuildRange errorRange = wmsQBDS.addRange(fieldNum(inventtable, Isopen));
errorRange.value(queryValue(NoYes::No));
errorRange.status(RangeStatus::Locked);
QueryBuildDataSource QBDS =
QBDS.addDataSource(tableNum(NewTable));
wmsHeaderQBDS.relations(true);
wmsHeaderQBDS.joinMode(JoinMode::ExistsJoin);
SysQuery::findOrCreateRange(wmsHeaderQBDS, fieldNum(NewTable, Newfield)).value('newrange');
}
No comments:
Post a Comment