Morten Aasheim <[EMAIL PROTECTED]> wrote:
Yes that's true. But where do you need this?
Morten
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Wahyudin Zakie
Sent: 6. april 2006 12:53
To: [email protected]
Subject: RE: [development-axapta] Alias Field in Select
I think it will get wrong result with that code :
for example i've got data :
Row 1 : B=2 C=2
Row 2 : B=3 C=3
Row 1 : B*C = 4
Row 2 : B*C = 9
SUM(B*C) = 13
But with your code :
SUM(B) = 5
SUM(C) = 5
SUM(B) * SUM(C) = 25
Please, any other solutions?
Zakie
Morten Aasheim <[EMAIL PROTECTED]> wrote:
As far as I know, this kind of syntax won't work in Ax.
You can do ex:
while select AccountNum, sum(Value1), sum(Value2) from custTrans
group by AccountNum
{
value = custTrans.Value1 * custTrans.Value2;
}
Regards,
Morten Aasheim
Peritus AS
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Wahyudin Zakie
Sent: 5. april 2006 16:44
To: [email protected]
Subject: [development-axapta] Alias Field in Select
Hi, i'm new in axapta.
How to implement this sql query in axapta :
"Select A, Sum(B * C) As D From TableX
Group By A"
I've got "syntax error"
Zakie
---------------------------------
How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call
rates.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
SPONSORED LINKS
Computer part Programming languages Microsoft axapta Support exchange
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "development-axapta" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
[Non-text portions of this message have been removed]
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
