Hello
Thanks for your reply.
I went through the first link given by you. Not sure where to include my query which is to be executed?
Also
Went through the script extension given in your signature. I am unable to compile that code after updating it for my requirement. I use Oracle SQL Developer to run my query. Details look like this
SQL Type: MSDASQL.1
Database Name: ENTUAT_SRV
Server Name: UAT4
While updating above details and executing the script I am getting the following error
Statement is not valid in a namespace.
Thanks in advance for your time and help.
Now lot of automation I have done in Keyword driven. Now I can not revert back my changes to Scripting
At this point in time I am planning to include it as a Run Script at the place where I want this script to be executed
Thanks
Eswara V
The first link is simply a starting point, describing the ADO objects available in TestComplete and giving a quick overview on how to use them for writing a query. Basically, what is in that link is what I used to build the script extension.
As for the script extension... what do you mean by "unable to compile that code after updating it for my requirement"? What did you change? How did you "compile" it? The extension is provided as-is so, any alterations you made to it I cannot support directly but I'd be happy to help you figure things out.
FYI, the extension as it is currently written only supports MSSQL and MYSQL. Support for Oracle would need to be added so, if you did so, I'd like to see what code you changed and how you implemented it.
Hello
I am not sure what I have to update for Oracle SQL. I was under impression that I should give required parameters for Databse Type and Name. I didn't modify the code given except inputting servernames and credentials. I have attached the properties details of my Oracle SQL developer.
I've attached the file too to this post.
Please give a look and advise me further
Thanks a lot
Regards
Eswara V
OK... first of all.... you copied my sample code from bitbucket... which, by itself, isn't bad... however, that code is in JavaScript/JScript... based upon the extension of the file you sent me, you're writing your code in VBScript. Syntax is ENTIRELY different so, that's why it won't work as written. You'll need to adapt my code for VBScript.
Secondly, since you need this done for Oracle, I can modify my extension to support Oracle connection strings... This will take a bit to do so, probably a few hours, but I don't mind. However, understand that I don't have an Oracle DB server to test this on so I can make what LOOKS to be right but I can't make any guarentees it works until you try it.
Thirdly, the following line is incorrect, even in Javascript:
queryObject = SQLUtilities.NewQueryObject(Update student_course_enrolment
Set WITHDRAWN_DATE = '01-AUG-18' where STUDENT_COURSE_ENROLLEMNT_ID IN (Select STUDENT_COURSE_ENROLLEMNT_ID from student_course_enrolment where student_id = XXXXXXX AND WITHDRAWN_DATE IS null ; ))
The reason being is that the query that you send to NewQueryObject needs to be a string. There are no string symbols around your query so it's not going to be able to determine what's the query... it's going to just fail at this point. Again, you'll need to make the necessary changes for VBScript but, in JavaScript, it should look like
queryObject = SQLUtilities.NewQueryObject("Update student_course_enrolment
Set WITHDRAWN_DATE = '01-AUG-18' where STUDENT_COURSE_ENROLLEMNT_ID IN (Select STUDENT_COURSE_ENROLLEMNT_ID from student_course_enrolment where student_id = XXXXXXX AND WITHDRAWN_DATE IS null ; "))
So... give me some time to get the extension updated for Oracle...