Langsung ke konten utama

Postingan

Menampilkan postingan dari September, 2016

QBDS Query Range

Range for string QueryBuildDataSource qbds; queryBuildRange qbr; ; qbds = this.query().dataSourceTable(tablenum(SalesQuotationTable)); qbds.clearRanges(); qbdr = qbds.addRange(fieldnum(SalesLine, PlanModelId)); //STRING qbds.addRange(fieldnum(SalesLine, PlanModelId)).value(SysQuery::valueEmptyString()); // = value('=""'); qbds.addRange(fieldnum(SalesLine, PlanModelId)).value('!=""'); qbds.addRange(fieldnum(SalesLine, PlanModelId)).value('1'); qbds.addRange(fieldnum(SalesLine, PlanModelId)).value(queryValue('!=' + planModel.PlanModelId)); queryBuildRange = queryBuildDataSource.addRange(fieldnum(WMSLocation, SPLCustAccount)); queryBuildRange.value('=""'); -> SPLCUSTAccount='' -> ((SPLCUSTAccount='')) queryBuildRange.value(SysQuery::valueEmptyString()); -> SPLCUSTAccount='' -> ((SPLCUSTAccount='')) queryBuildRange.value(queryValue('')); -> SPLCUSTAcco