Please
try maxof instead of max:
select
maxof(IDNumber) from myTable;
Bye,
Annette
Mit freundlichen Grüßen / Best regards
Dipl. Phys. Annette Theißen
System Software Entwicklung
______________________________________________
Viscom AG - Carl-Buderus-Str. 9-15 - D-30455
Hannover
Phone: +49/511/94996-0 - Fax: +49/511/94996-900
mailto:[EMAIL PROTECTED] -
http://www.viscom.de
-----Ursprüngliche Nachricht-----I have connected to an access database using selectstatement. Now I
Von: helpmeobwan [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 29. Juli 2004 12:00
An: [EMAIL PROTECTED]
Betreff: [Axapta-Knowledge-Village] SQL Select in axapata (X++)
want to connect to another table and get the lastest IDNUmber.
select max(IDNumber) from myTable;
lastIDProcessed = max(IDNumber);
But axapta reports a syntax error on the select statement. I do not
use SQL much but I think the statement is ok.
Does anyone know how to do this in X++ ?
J
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.