SV: [development-axapta] select maxcof(date fieldname) from tablename

Thu, 30 Sep 2004 04:46:57 -0700

You don't get a dataset in your example, you only get the maximum value of fieldname, and you can access the value by using tablename.fieldname.

If you want the newest records you could do this

while select tablename order by fieldname desc
{
    // test if fieldname changes, then break
    // else Output or calculating codes
}



________________________________

Fra: Mikael Dalg�rd [mailto:[EMAIL PROTECTED]
Sendt: 30. september 2004 12:23
Til: [EMAIL PROTECTED]
Emne: [development-axapta] select maxcof(date fieldname) from tablename


Hi



Regarding: how to find a dataset from a table, depending on the newest date:



I hope somebody can explain me, why I can't use the code below?



Select maxof(fieldname) from tablename

{

                      /*

                      Output or calculating codes

                      */

}





???



Hope that somebody can come up with an answer for this.



Best regards

Mikael Dalg�rd



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




Yahoo! Groups Sponsor     
ADVERTISEMENT
click here <http://us.ard.yahoo.com/SIG=129isg31p/M=295196.4901138.6071305.3001176/D=groups/S=1705006764:HM/EXP=1096626900/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com>      
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=286759450>      

________________________________

Yahoo! Groups Links


*      To visit your group on the web, go to:
      http://groups.yahoo.com/group/development-axapta/
       
*      To unsubscribe from this group, send an email to:
      [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
       
*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
click here

Yahoo! Groups Links

Reply via email to