Hi ,
try to use this, it MUST works

while select SUM(f3),f1,f2
        FROM xtable GROUP BY f1,f2
{
}

tomas

-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] Behalf Of pepejeans2k
Sent: Monday, August 15, 2005 12:00 PM
To: [email protected]
Subject: [development-axapta] While ....group ......error


To all,

Does any one ever face error when you do a while statement like this :

While field1, field2, sum(field3)
from xtable
group by field1, field2
{
    element.send(xtable);
}

While field2, sum(field3)
from xtable
group by field2
{
    element.send(xtable);
}

the report returns an error "Invalid Field" as it's looking for field1
in the second statement. If I swap statement 2 with statement 1, no
error. There must be some connection with the group by statement.

How do we overcome this error?

Best rgds,
BS








Yahoo! Groups Links








__________ Informace od NOD32 1.1191 (20050810) __________

Tato zprava byla proverena antivirovym systemem NOD32.
http://www.nod32.cz






SPONSORED LINKS
Computer part Programming languages Microsoft axapta
Support exchange


YAHOO! GROUPS LINKS




Reply via email to