Note/Update This topic started as a nested-if discussion but turned out to be about 'Test Variable' action and numeric values. Is it possible to create nested If...Then...Else conditions in Automation designer? The GUI allows to do it, however when I execute it, the second IF seems to be ignored. …

Additional info: Actually, the problem doesn't seem to be the IFs. The problem is the "Test Variable" action which doesn't work. It always evaluates to True. I've tried setting the variables as Local or Global without success. The variables hold the right values (I can see them in the email body a…

I tried recreating a more accurate logically situation to what you’ve got above and am also seeing an issue.

Thanks for checking. I found this thread https://forums.toadworld.com/t/using-variables-in-a-toad-automation-query/44477/7 where it’s mentioned that query iterator variables can not be used in a Test Variable action. It was for a previous version of Toad, so I wonder if this is still an issue.

Without query iterators I’m still hitting an issue with my second If…Then…Else also returning TRUE so it seems to be an issue with the nested If…Then…Else statements themselves.

To be clear, when I said… “But it looks like “Test Variable” won’t let you choose a Query Iterator variable. I can fix that for the next version but it won’t help you with 12.11.” …I was referring to the fact that if you click the button below, the GUI would not give you the option to choose a que…

@JohnDorlon That's good to know!. However, I still cant see the query iterator variables in the list: [image] [image] I'm using Toad for oracle 13.1.0.78. Is there anything else I'd need to do to see the variables? @mike.hamer I added a bit of things to your App1 and it seems to work fine for …

@humberto.higuera Sorry, I failed to check it in 13.1. Turns out I fixed it more recently than that. It’s in 13.2 beta.

Well, this is weird. The App works depending on the Query! If I run a simple query getting 3 values, assigning one of them (NUM2) to a variable TREAD, it works: [image] Result: [image] Now, if I use my query, which returns a row using the same column names as above, not changing anything else …

False alarm! Is not the query. If I change the NUM2 value to 2280 in the simple query it doesn’t work anymore. It works with a value of 60 but not with a value of 2280 Weird thing

Automation designer - Numeric variables in Test Variable action

Toad for Oracle & DevOps Toolkit

mike.hamer February 1, 2019, 7:03pm 3

I’ve attached a small example of two nested If…Then…Else statements that you can import and try. They work based on a TEST variable defined in Options and react accordingly when I update it.

App1.txt (7.3 KB)

Topic		Replies	Views
Automation - script to update user variable Toad for Oracle & DevOps Toolkit	4	2318	January 17, 2018
Using Variables in a Toad Automation Query Toad for Oracle & DevOps Toolkit	20	8278	August 30, 2024
Toad Automation Designer - Set Variable action - cannot use expression Toad for Oracle & DevOps Toolkit	3	1176	January 19, 2018
Automation Designer variables for data export Toad for Oracle & DevOps Toolkit	14	2566	February 17, 2014
Variables in Toad for Oracle Toad for Oracle & DevOps Toolkit	17	15328	January 12, 2023

Automation designer - Numeric variables in Test Variable action

Related topics