Hi Srinath, Seems that dynamically generated query is having some issue and its not gettting exected. Can u share the customization related to query generation logic, this will help getting upto exect issue. Regards, Nitesh Ranjan
--- On Mon, 5/10/10, srinath s <s_shreen...@yahoo.co.in> wrote: From: srinath s <s_shreen...@yahoo.co.in> Subject: [Axapta-Knowledge-Village] Dynamic x++ query problem To: development-axa...@yahoogroups.com, Axapta-Knowledge-Village@yahoogroups.com Date: Monday, May 10, 2010, 10:20 AM 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