QueryRun qr;
QueryBuildRange qbrDimention
;
qr = new QueryRun(this);
qr.query().dataSourceNo(2).addRange(fieldnum(VendTrans,transDate)).value(date2strusr(fromDate)+".."+date2strusr(toDate));
qbrDimension = this.query().dataSourceNo(2).findRange(fieldnum(VendTrans,dimension));
qr.query().dataSourceTable(tablenum(VendTrans)).sortClear();
qr.query().dataSourceTable(tablenum(VendTrans)).addSortField(fieldnum(VendTrans,RecId),SortOrder::Ascending);
while(qr.next())
{
_vendTable = qr.get(tablenum(VendTable));
_vendTrans = qr.get(tablenum(VendTrans));
if(qr.changed(tablenum(VendTable)))
{
if(first)
element.execute(2);
executed = false;
element.newPage();
element.send(_vendTable);
range = _vendTable.AccountNum;
element.execute(1);
first = true;
}
}
QueryBuildRange qbrDimention
;
qr = new QueryRun(this);
qr.query().dataSourceNo(2).addRange(fieldnum(VendTrans,transDate)).value(date2strusr(fromDate)+".."+date2strusr(toDate));
qbrDimension = this.query().dataSourceNo(2).findRange(fieldnum(VendTrans,dimension));
qr.query().dataSourceTable(tablenum(VendTrans)).sortClear();
qr.query().dataSourceTable(tablenum(VendTrans)).addSortField(fieldnum(VendTrans,RecId),SortOrder::Ascending);
while(qr.next())
{
_vendTable = qr.get(tablenum(VendTable));
_vendTrans = qr.get(tablenum(VendTrans));
if(qr.changed(tablenum(VendTable)))
{
if(first)
element.execute(2);
executed = false;
element.newPage();
element.send(_vendTable);
range = _vendTable.AccountNum;
element.execute(1);
first = true;
}
}
No comments:
Post a Comment