MOSS2007 with SP3.
I have a list with many items. From code I get items using simple criteria. (give me all products that have DeliveryDate between in a specific time interval and the field Customer not null) For this I build a CAML query and use it in code (mList.GetItems(query)).
Before having 2000 items all was OK.
Now I have 2077 items and the error that I receive is “Unknown SQL Exception 4104 occured. Additional error information from SQL Server is included below. The multi-part identifier "t16.nvarchar1" could not be bound.”
Checked on the internet and hoped that a last service pack will solve the problem. But problem persist. Checked the same simple query in CAML Builder.... same error. If I remove items until I have only 1999 in the list the issue is gone.
What can I do?
Now in the UI I did a new View that will display all items (set RowLimit to 5000 to be sure) and this work ok, all items are displayed. - I cannot use this view in code because I have to add dinamicaly difrent filter criterias.
But I need to return items in code....so again what is to be done ?