Hi Roberto
Try this
static void Job5(Args _args)
{
Query eisQuery = new Query();
InventTrans eisInventTrans;
QueryRun eisQueryRun;
;
//eisInventTrans.Qty
eisQuery.addDataSource(TableNum(InventTrans));
eisQuery.dataSourceTable(TableNum(InventTrans)).orderMode(OrderMode::GroupBy);
eisQuery.dataSourceTable(TableNum(InventTrans)).addSortField(fieldnum(InventTrans,TableId));
eisQuery.dataSourceTable(TableNum(InventTrans)).addSelectionField(fieldnum(InventTrans,Qty),SelectionField::Sum);
eisQueryRun = new QueryRun(eisQuery);
while(eisQueryRun.next())
{
eisInventTrans = eisQueryRun.get(tableNum(InventTrans)) ;
print eisInventTrans.Qty;
}
pause;
}
Vishal
>
>
> 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.
