Max length of custom sql

[lj1]

I am using a dynamic complex sql statement to load a grid. Works great until it hits a 1000 byte limit and truncates, causing the query to fail. Is 1000 bytes the limit? (versions 4.2.3 and 4.1.6)

[David]

Sorry for the problems.

See here for a discussion on 2 different SQL modes that can be used:

http://www.profoundlogic.com/docs/displ ... L+Security

I bring this up, because the limitation would differ depending on the mode used.

With Enhanced mode, the limtation should be 32000B. Without, it should be 2048B. Determined just by glancing over the processing -- we'd have to test to see if there is something that is causing further limitations and get back to you.