Hi Experts
In the front end, I load a collection of AccProduct. The logic behind is a bit complex, but essentially I end up using an IN clause and pass more than 8000 entries in it, then I get this erro
An exception has occurred while executing the form method F0_ctl00_ControlRef8_ControlRef15_CCCControlRef2_ControlRef8b_Main_Main_Tab1_ctl00_T0_ctl00_Tab4_ctl00_T0_ctl00_ControlRef28_Container8_GridBand1_gridLoader_R0C_Container24_ToolbarButton1_Method.
One or more errors occurred.
One or more errors occurred.
One or more errors occurred.
The IN clause exceeds the limit of 8000 elements. Modify the query.
I don't see any inherent limitations in SQL about this, is this part of the product or a configuration somewhere which limits the amount of entries in an IN clause?
Thanks
Kin