Hi guys.

I have a report with two data source joined by a
relation (LedgerTable and LedgerTrans) and I need to
do
something in the fetch method like:

public boolean fetch()
{    
    QueryRun qr;
    LedgerTrans lTrans;

    qr = new QueryRun(this.query());
    while (qr.next())
    {
      lTrans = qr.getNo(2);
      while (lTrans.AccountNum)
      {
        info(lTrans.AccountNum);         
        //for example
        next lTrans;
      }
    }
}

But the problem is that 'next lTrans' is not allowed
in joined cursor, the question is how can I access
the second datasource (lTrans)?

In other words, is it possible replace the below code
with queries?:

while select LedgerTable {

  ...

  while select LedgerTrans where
LedgerTrans.AccountNum == LedgerTable.AccountNum {
    ...
}
}

I wonder if somebody knows... thanks.

__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis! 
Regístrate ya - http://correo.espanol.yahoo.com/ 


Sharing the knowledge on Axapta. 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/Axapta-Knowledge-Village/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to