query too complex error 3360

[thread]

Hi all,

i build automation that collect information from a file and building
query with criteria
problem starts when the criteria is too complex
is it posible to some how increase the memory or the limit for the
query or there is another way around

 

[Ed Metcalfe]

Hi all,

i build automation that collect information from a file and building
query with criteria
problem starts when the criteria is too complex
is it posible to some how increase the memory or the limit for the
query or there is another way around

What's the query? Can you post the SQL? Optimisation of the query or a
change to the way you are running it will likely help.

Ed Metcalfe.

 

[thread]

its very long query,basicly using alot of iif and criteria,i assume
that this is something that should be changed