RE: [Axapta-Knowledge-Village] Question about Queries.

Sorry, I mixed up sum with count :) Ozan -Original Message- From: Ozanhan Anaç [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 12:21 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Question about Queries. Hello Roberto, Write; TableX

RE: [Axapta-Knowledge-Village] Question about Queries.

Hello Roberto, Write; TableX TableX; Select sum(RecId) from TableX where TableX.FieldY == Something; Result is = TableX.RecId; Ozan -Original Message- From: Roberto Pineda [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 7:02 PM To: Axapta-Knowledge-Village@yahoogroups.com;

Re: RE : [Axapta-Knowledge-Village] Question about Queries.

Thanks a lot Steeve! --- Steeve Gilbert <[EMAIL PROTECTED]> wrote: > Here's a modified version that do what you wanted : > I used SalesLine just to check if it compiled. > > Amount SumAmount; > Query queryA; > QueryRun queryrunA; > QueryBuildDataSource qbdsQ = queryA.dataSourceNo(1); > SalesLin

RE : [Axapta-Knowledge-Village] Question about Queries.

Here's a modified version that do what you wanted : I used SalesLine just to check if it compiled. Amount SumAmount; Query queryA; QueryRun queryrunA; QueryBuildDataSource qbdsQ = queryA.dataSourceNo(1); SalesLine salesL; queryA = new Query(tablenum(SalesLine)); qbdsQ.addRange(fieldnum(SalesLine