Dynamic x++ query problem

Discussion:

(too old to reply)

Sri

2010-05-11 04:26:01 UTC

Hi folks,

I have done some customization in which i am 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

SysProg

2010-05-11 17:14:04 UTC

Permalink

Hi Sri,

See this blog:
http://www.eggheadcafe.com/software/aspnet/30225272/the-upper-limit-of-open-c.aspx

I think the problem might be too many cursors due to nested sql statements.
Give it a shot.

Hope this helps.

Regards.

Post by Sri
Hi folks,
I have done some customization in which i am 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

Johannes Astner

2011-09-07 13:14:00 UTC

Permalink

Hi Sri,

if you have a range which you assign comma separated values to (like a queryBuildRange which is filled with RecIds) use the global method queryValue(anytype _any). This helped in my case.

Johannes

Post by SysProg
Hi Sri,
http://www.eggheadcafe.com/software/aspnet/30225272/the-upper-limit-of-open-c.aspx
I think the problem might be too many cursors due to nested sql statements.
Give it a shot.
Hope this helps.
Regards.