Hi, I've been with an error that I can not solve, I hope you can help me.
I am trying to execute the following routine in one ("tMySqlRow")
"SET @ID = (select min (ID) from execution where PERIOD = concat (year (now ()), LPAD (month (now ()), 2, 0)) and IDINDICATOR = 1); delete from execution where id = @ID "
but I always get the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete from ejecucion
where id = @ID' at line 4
any ideas? I do not know how to solve it.
can't have multiple commands in one sqlrow component by default.
Try adding this in the component:
Update Additional JDBC Parameters to include "allowMultiQueries=true".