2 Replies Latest reply on Jan 2, 2014 11:26 AM by Mark Lindberg

    If statement inside SQL Statement Info Editor

    Ali Ahmed

      Hi There,

       

      I'm trying to make a conditional insert statement in the process designer using "SQL Statement Info Editor". And I'm getting "Invalid SQL statement".

      Is there any alternative to implement this or is it just a syntax error to what I'm doing?

      This is just an example of the issue, if I remove the if statement it will work.

       

      SQL Statment Info Editor.jpg     .

      Thanks,

      Ali.