Hi there,
is there a way to catch feedback from the SQL process?
When I try to insert a duplicate key the message appears on the screen (Error. Violation of PRIMARY KEY constraint....................) which is as expected. Is there a way to put this message in a variable that can be used in en email?
Thanks!
is there a way to catch feedback from the SQL process?
When I try to insert a duplicate key the message appears on the screen (Error. Violation of PRIMARY KEY constraint....................) which is as expected. Is there a way to put this message in a variable that can be used in en email?
Thanks!
Hi James
I am afraid there is no way. The only information that you get from a SQL sentence and is available for the next items are:
- if it was successful or not. See the automated processes run conditions:
https://www.emailparser.com/d/automated-processes-basics/run-conditions-automated-process-chaining
- the result from a SQL SELECT sentence:
https://www.emailparser.com/d/automated-processes-databases/handling-sql-select-result
The only workaround for this would be creating a script (C#) that does the SQL operation itself and captures the reply from the server and creates a new field from that.
I am afraid there is no way. The only information that you get from a SQL sentence and is available for the next items are:
- if it was successful or not. See the automated processes run conditions:
https://www.emailparser.com/d/automated-processes-basics/run-conditions-automated-process-chaining
- the result from a SQL SELECT sentence:
https://www.emailparser.com/d/automated-processes-databases/handling-sql-select-result
The only workaround for this would be creating a script (C#) that does the SQL operation itself and captures the reply from the server and creates a new field from that.
