[development-axapta] Query with ORDER BY and GROUP BY

Hi there! Can i use the ORDER BY and the GROUP BY Clause in one SQL Statement? In SQL92 it would look like this: SELECT SUM(QTY) AS Qty, SUM(LINEAMOUNT) AS Amount, ITEMID FROM CUSTINVOICETRANS WHERE (INVOICEDATE = CONVERT(DATETIME, '2004-01-07 00:00:00', 102)) GROUP BY ITEMID

RE: [development-axapta] display method

Hi Steeve, i feel that the use of display is mainly to reduce the unnecessary adding of fields in the table (and hence increase the database size) , say for example if one table is used in many forms/reports and we need one particular field (which could be got from any other table with

RE : [development-axapta] Permission group access

You can put security key on pretty much any object in the form I think. I would try using security key first before going with some coding. If it really can't be done with the basic security key functionality here's what I would do : I would suggest you to create 2 security keys (one for

Re: SV: [development-axapta] OLAP Cubes

Thank you Pieter. I think you are correct. Even if I create a method to concatenate two fileds, in query used by OLAP cube, I think it is ignored when running query and not visible to cube manager. Ciao Alberto --- In [EMAIL PROTECTED], Pieter Wijnen [EMAIL PROTECTED] wrote: I'm afraid

RE : [development-axapta] display method

I can understand that, but why do I need to add the display keyword if I want to call the method from a control?  If I don't put display then it won't compile the object because a control is calling a nondisplay method.  The message given is Method getDateRange is not an edit/display

Re: [development-axapta] Query with ORDER BY and GROUP BY

Hi Werner: The sintax of the first SQL Statement is good, a SQL Server Query, but in Axapta you can't use at where sintax likecustInvoiceTrans.InvoiceDate == str2date('20040107', 321), you only can use Table fields like Custtable.Accountnum = Custtrans.Accountnumby example. You can't

AW: [development-axapta] Query with ORDER BY and GROUP BY

Hi! Thank you for your answer, but the problem isn't the criteria with the InvoiceDate, that works. The Problem is, that Axapta doesn't accept the GROUP BY and the ORDER BY clause in one Statement. while select sum(Qty), sum(LineAmount) from custInvoiceTrans group by ItemId order by

[development-axapta] Re: Query with ORDER BY and GROUP BY

hi! I'm reading : As opposed to SQL, X++ doesn't allow GROUP BY and ORDER BY in the same SELECT statement. This is written in the Axapata Language Reference on page 63. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To

RE: [development-axapta] Query with ORDER BY and GROUP BY

You can always go external right to sql using Connection con = new Connection(); Statement sqlStmt = Con.createStatement(); ResultSet sqlTable; Str sqlStr; sqlStr = your select statement sqlTable = sqlStmt.executeQuery(sqlSTR); while (sqlTable.next()){

RE: [development-axapta] Query with ORDER BY and GROUP BY

One additional thing dont forget to set the company when going external, here is select statement I did on a memo field sqlSTR = strFmt(select recID from AAA_Tracker where notes like '\%%1\%' AND dataAreaId = '%2', Part2, datAreaId); you cant do that in Axapta either. Don

Re: RE : [development-axapta] display method

Hi, Maybe, it's because the axapta compiler for X++ needs a display method to check the parameter syntax.Because, you cannot create a display method using a complex arguments. Hence, the control will not be able to use any method other than display method, because non-display method has not