Forum Discussion
FYI, one of the pros of script extensions is that ANYONE can edit a script extension, not just the developer. Change the extension from tcx to zip, open it in your favorite compression utility, find the code file, edit, update the zip, change the extension to tcx... and you're golden.
Okay. Thanks for telling that. Our environment is very restricted if download a file from net and try opening I will be prompted with Admin credentials which I dont have
Thanks
Eswara V
- tristaanogre6 years agoEsteemed Contributor
OK... I've made an update to the SQLUtilities.tcx file. Should be reading as version 4.1 now. Please download and let me know if this works for you.
- tristaanogre6 years agoEsteemed Contributor
OK...
contacteswart wrote:
- Updated the code as per my requirement
The line for SetSQLType... change the parameter from MSDASQL.1 to ORACLE.
contacteswart wrote:- change extention ot .js > Save it & Close it
Not sure this is going to work as you intend it. When you created your project in TestComplete, you selected a script code language. This is the language you should be writing your script code in. So, just changing the extension is not going to get it to work in TestComplete.
Additionally, based upon step 3, you're writing this OUTSIDE of TestComplete. The script extension won't work outside of TestComplete. Everything that I've been instructing in has been assuming that you are writing your script code in the code editor built in to TestComplete. Please review https://support.smartbear.com/testcomplete/docs/scripting/overview.html
So... double clicking on the JS file isn't going to execute anything. This is something that needs to be created in TestComplete and then use, in your keyword test, the "Call Script Routine" operation to execute the two different functions...and, again, you need to make sure the code is written in the appropriate code language that you selected when you created your project.
- contacteswart6 years agoOccasional Contributor
Hello
I downloaded the TCX file and noted the updated .Js file. Code looks quite lenghty and I lost on where to update what?
Sorry I am not too techy :smileysad:
Regards
Eswara V
- tristaanogre6 years agoEsteemed Contributor
In this case, you don't need to update anything in the code.
So, go back to the original attempt you made with SQLUtilities.VBS that you sent earlier... convert that code to VBScript. And, in the line where you SetSQLType, set it to "ORACLE" and you should be good to go.
- tristaanogre6 years agoEsteemed Contributor
Just following up contacteswart... have you gotten anywhere with this yet?
- contacteswart6 years agoOccasional Contributor
How to call you? i.e your first name or calling name
Hi there,
Not yet. while I was looking into this issue new requirement came up. Currently working on new requirement. Once it is done I will move back to your solution.
Will keep you posted about the out come
thanks a lot for your time and explanation
Regards
Eswara V
- tristaanogre6 years agoEsteemed Contributor
Most folks call me Rob or Robert. That's fine for me.
- contacteswart6 years agoOccasional Contributor
Hello Robert
I have attached the JS which you shared and I updated as per my project condition.
Steps I have executed are
- Updated the code as per my requirement
- change extention ot .js > Save it & Close it
- Double click on .js file
No errors are returned
How will I come to know 'myRecords' got populated with enrollment date?
or
How to confirm that connection got established and query execution is sucessful?
Thanks
Eswara V
- contacteswart6 years agoOccasional Contributor
Thanks for detailed explanation Robert. Now I need to do lot of work to get this done.
I wish me all the best :-)
have a happy week end
Regards
Eswara V
Related Content
- 3 years agomsalvador
- 2 years agoletoged
- 6 months agosohailalam2696
Recent Discussions
- 3 days agovladd1