Toad World® Forums

Automation - variables


#1

Component Execute_1 defines 2 variables: for rowcount and for result.
However, those variables are not visible in expression builder if “if…condition” component.

Butter

variable1.png

variable2.png


#2

This is a known issue (and btw, it quite maybe not a problem). Current variables implementation restricts variable visibility to a container where an activity defining such variable is located. In your case EXECUTE_1_RCOUNT is visible only inside Connection_1 container. If you put Execute_1 outside Connection_1, then EXECUTE_1_RCOUNT becomes visible to the whole script.

Btw, why use Connection_1 at all?

Thanks,

Igor.


#3

Connection_1 has been added by Toad.


#4

You don’t need it. Move Execute_1 out of it and remove Connection_1 from the script.

Igor.