Building a query object

static int SumOqty(str itmid,str Sid)

{

real sumoq;

Query query;

QueryBuildDataSource queryBuildDataSource1;

QueryBuildRange queryBuildRange;

QueryRun queryRun;

PurchLine   _purchLine;

InventBatch  _InventBatch;

int Counter;

real result;

_MOHData moh=new _MOHData();

;

/////////////////////End Declaration//////////////////////////////

Counter=0;

sumoq=0;

result=0;

query = new Query();

queryBuildDataSource1 = query.addDataSource(tablenum(PurchLine));

queryBuildDataSource1.addRange(fieldnum(PurchLine, ItemID)).value(queryValue(itmid));

queryBuildDataSource1.addRange(fieldnum(PurchLine, PurchId)).value(queryValue(Sid));

queryBuildDataSource1.addRange(fieldnum(PurchLine, DIST)).value(queryValue(NoYes::No));

queryRun = new QueryRun(query);

while (queryRun.next())

{

_purchLine = queryRun.get(tablenum(PurchLine));

//if(_purchLine.ItemId==itmid)

{

sumoq+=_purchLine.PurchQty;

//nfo(int2str(sumoq));

Counter++;

}

}

return sumoq;

}