Toad World® Forums

Automation variable returning numeric value instead of text

I have an automation script that uses 3 variables. All 3 variables are set in a loop function that is reading the values in from a previous query stored in the table Problem_Jobs. The query returns 3 columns Problem_Type, JNAME and Owner_Email. The set variable step in the loop sets the variables for Problem_Type and Owner_Email just fine. When it sets Job_Name to Problem_Jobs.JNAME the result is zero instead the text in JNAME. All three fields are text fields. All three variables should be varchar. Is there anyway to force the variable type? or why is one not working like the others?

Can you please post here or send me directly ( your tas script?



I fixed it. I think by putting the initial value in quotes (“Name of Job”) in the step when I creat the variable solved it.