Hi,
I am joining 6 tables in X++ code. I am Getting the following error.
How to Resolve this?
The total, internal size of the records in your joined SELECT statement is 55980 bytes, but Microsoft Dynamics is by default performance-tuned not to exceed 35576 bytes.
It is strongly recommended that you split your table(s) into smaller units.
Alternatively, you have to specify a ‘Buffer size’ value of 26 Kbytes or higher in the ‘SQL’ tab page in the Microsoft Dynamics Configuration Utility. The default value is 24 Kbytes.
Exit Microsoft Dynamics immediately, and follow the directives above. Use of the table(s) will cause unpredictable results.
