Please forgive me if I'm posting this to the wrong section. I'm upgrading from Automate 9 to Automate 11 and I'm having difficulty finding the answer to the question I need answered. In Automate 9 I could use a variable in the Sql Statement to pull information about a specific record. When I imported this code into 11 I get the error The specified table or object does not exist, I'm connecting to the db properly as I can test the connection and I get test succeeded. I've tried different permutations on the variable but so far have had no luck. I've attached a copy of the sql statement. Any help would be greatly appreciated.
Thank You
Mike