Re: AW: [Axapta-Knowledge-Village] SQL Select in axapata (X++)

select maxof(IDNumber) from myTable; lastIDProcessed = myTable.IDNumber; --- Theissen, Annette [EMAIL PROTECTED] wrote: Please try maxof instead of max: select maxof(IDNumber) from myTable; Bye, Annette Mit freundlichen Grüßen / Best regards Dipl. Phys. Annette Theißen

RE: AW: [Axapta-Knowledge-Village] SQL Select in axapata (X++)

Title: Message Thanks all. That works great. Jason -Original Message-From: Girish B [mailto:[EMAIL PROTECTED] Sent: 29 July 2004 11:49To: [EMAIL PROTECTED]Subject: Re: AW: [Axapta-Knowledge-Village] SQL Select in axapata (X++) select maxof(IDNumber) from myTable