DB SQL Executor flow variable problem
Hello
I am doing an Update on a DB through a DB SQL Executor node (must be that node), and one of the fields I need to update is a SQL statement that comes in as text. The problem is that the SQL statement references a flow variable (not from the workflow being executed) and I need the statement to be as-is with the variable name (not the value because the variable does not exist in the workflow in which it is executed), and I can’t find a way, so the SQL execution for the Update tries to find the value of a variable that does not exist. How do I make that variable go as text?
The SQL:
UPDATE xx.xxxx.xxx
SET sentencia_sql = ‘select * from BIProteccionDW.APOLO.DimPersonas WITH(NOLOCK) where skPersona between $${DRangoInicio}$$ and $${DRangoFinal}$$’,
WHERE pkprogramacioningesta = ‘10’;
The node looks for $${DRangoInicio}$$ and $${DRangoFinal}$$', but I just need to read the name but not the value, so I’m getting the error shown below.
Help please