RE: [development-axapta] Alias Field in Select

[Morten Aasheim]

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: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Wahyudin Zakie
Sent: 5. april 2006 16:44
To: development-axapta@yahoogroups.com
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

            
---------------------------------
New Yahoo! Messenger with Voice. Call regular phones from your PC and
save big.

[Non-text portions of this message have been removed]






 
Yahoo! Groups Links



 







  




  
  
  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.