Query too large to be displayed

[bidev]

I have a query that has a long list of item #'s used in the "where" clause in selecting records of MS SQL database.  Because it is a dynamic calling to the database, I am prompted by Native the Database Query approval window, which I normally would click "Run" to start the execution.    But this time, there was a message, "Query too large to be displayed", and I couldn't run.

Is there a way to skip the prompt?  Or any other ways to work around.  Thank you if you can help.

[ImkeF · Accepted solution]

You can adjust the query-option so that the approval will not be required. But warning: This is a global setting, so it will applied to other queries as well:

Alternatively you could try to shorten your query, accept the approval and then put back your original query. But this might then not work for other users.

[bidev]

Hello Imke,

Thank you very much for your help and after unselected that option, I could run without any problem!  Thanks again.