Best regards
Mikael Dalg�rd
-----Oprindelig meddelelse-----
Fra: Dahlsgaard Jan [mailto:[EMAIL PROTECTED]
Sendt: 30. september 2004 13:35
Til: [EMAIL PROTECTED]
Emne: SV: [development-axapta] select maxcof(date fieldname) from tablename
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=gr
oups/S=1705006764:HM/EXP=1096626900/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.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 Links
| Yahoo! Groups Sponsor | |
|
|
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]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
