Wednesday, 18 January 2012

Apply range in query

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;
        }
}

No comments:

Post a Comment