x++ query select from markuptransHistory table
MarkupTransHistory _markupTransHistory; Query query; QueryRun queryRun; QueryBuildDataSource queryBuildDataSource; QueryBuildRange queryBuildRangeTableId,queryBuildRangeRecId; select _purchLine where _purchLine.LineNumber == _vendPurchLineAllVersions.LineNumber && _purchLine.PurchId == _vendPurchLineAllVersions.PurchId; query = new Query(); query.validTimeStateAsOfDateTime(_vendPurchLineAllVersions.VersionDateTime); queryBuildDataSource = query.addDataSource(tableNum(markupTransHistory)); query.validTimeStateAsOfDateTime(_vendPurchLineAllVersions.VersionDateTime); queryBuildRangeTableId = queryBuildDataSource.addRange(fieldNum(markupTransHistory,TransTableId)); queryBuildRangeTableId.value(queryValue(_purchLine.TableId)); queryBuildRangeRecId = queryBuildD...