RE: [development-axapta] Alias Field in Select

Fri, 07 Apr 2006 00:29:39 -0700

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



Reply via email to