I have connected to an access database using selectstatement. Now I 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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/