amosrinat Posted July 7, 2020 Share Posted July 7, 2020 Hi, I have a working query, tested by copying the output of the $query variable in AutoIT to SQL Management Studio. The output of the above query in SQL studio is a single record (line) and seven columns. All are text. In AtutoIT, I execute the query - $result = $adCN.Execute($sQuery) and fail in getting the results. the line - $sString = $result.getstring() gives me the error: "The requested action with this object failed". When i hover my mouse over the variable $result a popup designates it's an object which in turn confirms the code is OK up to that point. Why is Getstring() not working? What else should I do? Thank you for your help, Amos Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted July 7, 2020 Moderators Share Posted July 7, 2020 Moved to the appropriate forum. Moderation Team "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
amosrinat Posted July 8, 2020 Author Share Posted July 8, 2020 Found the reason. Though the SQL code works fine with CTE temporary table, It doesn't work in the AutoIT code. I will create a view in SQL and will call it from AutoIT. Amos Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now