Try something like this (example on custtrans)
query = new Query();
qbds = query.addDataSource(tablenum(CustTrans));
qbds.addRange(fieldnum(CustTrans, Accountnum)).value('test');
qbds.addSortField(fieldnum(CustTrans, AccountNum));
qbds.orderMode(OrderMode::GroupBy);
qbds.addSelectionField(fieldnum(custTrans, AmountMST), SelectionField::Sum);
queryRun = new QueryRun(query);
while (queryRun.next())
{
custTrans = queryRun.get(tablenum(CustTrans));
info(strfmt("Balance for customer '%1': %2", custTrans.AccountNum, custTrans.AmountMST));
}
Br,
Lars
-----Original Message-----
From: Roberto Pineda [mailto:[EMAIL PROTECTED]
Sent: 10. marts 2005 18:02
To: [email protected]; [email protected]
Subject: [development-axapta] Question about Queries.
Hello to All
Is there a way to make a query that gives the same result of doing:
select sum(FieldX) from TableX where FieldY == Something;
The way i found goes like this, but I am sure that there should be a nicer way.
Amount SumAmount;
Query queryX;
QueryRun queryrunX;
TableX tableM;
queryX = new Query(tablenum(TableX));
queryX.dataSourceNo(1).addRange(fieldnum(TableX,
FieldY)).value('Something');
queryRunA = new QueryRun(queryA);
while(queryRunA.next()){
tableM = queryRunA.getNo(1);
SumAmount += tableX.FieldX;
}
It's too slow.
Thanks if somebody can help me.
Roberto
_________________________________________________________
Do You Yahoo!?
Informaci�n de Estados Unidos y Am�rica Latina, en Yahoo! Noticias.
Vis�tanos en http://noticias.espanol.yahoo.com
Yahoo! Groups Links
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
