Posted Fri, 05 Jun 2020 22:04:39 GMT by

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

 

 

Posted Fri, 05 Jun 2020 22:51:10 GMT by

I found the issue and resolved my own problem.

Mike

You must be signed in to post in this forum.