Hello Coomunity, I have a keyword test which runs for a product purchase. Before continuing with another run I need to run an Update SQL query to ensure the product is deleted from users purchase list. How can I do that. I mean I want to insert this at the end of script run so that Product is deleted automatically every time when script runs. Thanks in advance for your help Eswara V

Honestly, it's a LOT easier to write SQL interaction code in Script rather than trying to shoe-horn it into the format of keyword testing. Check out https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sources/databases/ado-components.html OR, follow the link in my signature... there's a script extension I wrote that encapsulates a lot of this stuff for executing SQL queries.

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.

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.

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.

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

I need to run a SQL update command once keyword test completes its run. I have DB connected to TC

18 Replies

tristaanogre
Esteemed Contributor
6 years ago
Honestly, it's a LOT easier to write SQL interaction code in Script rather than trying to shoe-horn it into the format of keyword testing.

Check out https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sources/databases/ado-components.html

OR, follow the link in my signature... there's a script extension I wrote that encapsulates a lot of this stuff for executing SQL queries.
- contacteswart
  Occasional Contributor
  6 years ago
  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
  - tristaanogre
    Esteemed Contributor
    6 years ago
    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.

Forum Discussion

I need to run a SQL update command once keyword test completes its run. I have DB connected to TC

18 Replies

Related Content

Connection reset

JDBC connection error indicating SSL issue

Getting error connecting emulator

javax.net.ssl.SSLException: Connection reset error

LDAPS connection

Recent Discussions

convert absolute path to relative path

Multiple execution of a test plan with different values from an Excel table

Searching for mapped object took too much time msg

mht files are by default opening in Edge browser and its blank

Azure Devops Integration supports Testcomplete Base Fixed Dektop Module License