It looks like you are not able to reference an index of a table in a where statement. So I ended up having to do this:
( ( ( ( ( ( LOGDATE in @LR_01 ) and ( LOGDATE in @LR_02 ) ) and ( PLANT in @LR_03 ) )
Not ideal but you do what you have to.
Tipp: First write it statically to see the syntax errors, then transfer to the dynamic token.
1) you should be able to use a single clause for all those entries, e.g. LOGDATE IN @LR_WHERE if LR_WHERE is a range table.
2) check if open and close parenthesis match
JNN
Add comment