Hi Roberto,
I've commented out the piece of code, which you don't need to use.
So the on the first iteration you can retrieve the first ltrans record, on the
second iteration - the second one. If you want to check whether accountnum has
been changed or not, you can track it by using temp variable, or use following
validation
if (!qr.changed(tablenum(LedgerTable))
I hope it will help.
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;
}
*/
}
}
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Roberto Pineda
Sent: Thursday, July 28, 2005 8:18 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Question about two datasource query
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
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/
