Hello all,

We have to evaluate really big expression (SQL Statement) about 10,0000 symbols.
But EVALUATE() function has a restriction of 255 symbols for a parameter.
Does anyone know any workaround for this problem?

Thanks in advance, Paul.


The EVALUATE() limit are fixed by:

Maximum # of characters per command line 8192
Maximum length of a string literal 255

Then, you can EVAL() a 8192 string expression with a max string literal component with 255 chars.
For more 8192 chars you can split the expression into subexpressions.

Macro and EXECSCRIPT ( very slow ) are not usable because these have the same 8192 limits.

True value is 8191.