General information
Category:
Coding, syntax & commands
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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only