I've seen this when selecting too many lines during a transition. For instance, if your on the sales order form, select a large group of orders, and try to invoice them. The reason is because AX is trying to append a bunch of nested if's with the salesid = XXX instead of using an in clause.
Depending on how you've built and selected data for your query you might be running into the same problem. The way we get around it with the invoicing is to select just one sales order, then use the query selector in the popup form (saleseditlines) to use wildcards to select the needed rows. --- In development-axapta@yahoogroups.com, srinath s <s_shreen...@...> wrote: > > > Hi folks, > > I have done some customization in which doing dynamic query generation. Now i > am getting the following error message. > Stack trace: The operation that you are performing generates a SQL statement > that contains too many nested statements. Break the operation into multiple > parts, and try again. > > (C)\Classes\QueryRun\next > > Could anybody help on this. Otherthan changing the existing code for > generating the dynamic query, Is it possible to fix with other way. > > Waiting for a response. > > Regards, > Srinath. S > > > > > [Non-text portions of this message have been removed] >