Passing return code from previous step as argument to the next step

Discussion created by maho on Apr 24, 2013
Latest reply on May 15, 2013 by MBroadbent-esristaff

Is it possible to pass the return code from one step as the argument to a next step?

If have a step where the user selects one of three values in a question step. I would like to pass that answer into a JTXExecuteSQL step as part of the SQL to update a field in an extended property table.

so if I have an extended property table EXT_PROP I'd like to do something like:

update EXT_PROP
set Status = [return code from previous step]
where job_id = [JOB:ID]

If that's not possible, is there another way to accomplish this? As a work-around I configured as many JTXExecuteSQL steps as I have return codes and used conditional returncodes on the connectors to execute the correct update statement, but it feels like a clumsy way to implement what I want.