- tristaanogreEsteemed Contributor
The syntax I use in the example is generally usable in either.
One thing I just realized... the example I gave isn't going to work because the extension is written in JScript but I'm depending upon an output parameter. So, what you're going to want to do is probably use the method for the record set as documented in the ReadMe I PM'd to you... That will return the actual SQL records in an ADO record set object that you can then traverse and check for content.
I've created a "bug" in my repository to correct this oversight so that folks can get a "rows affected" response if they want... that is, again, a backlog item for me so it might take a bit. In the meantime, the work around I suggested SHOULD work for you. - mgroen2Super Contributor
No problem. I will create a new project.
Do I need to select JavaScript or JScript? Or does it make no difference?
- tristaanogreEsteemed Contributor
Sorry, I should mention that the example code is JScript/JavaScript. If you're using VBScript, the syntax and structure is going to change in generating the code. I'm not a VBScript guy... I can struggle through and give you something but I'm not confident enough in my VBScript skills to be a whole lot of help.
- mgroen2Super Contributor
So, I copied/paste the example code from: https://bitbucket.org/privateteamogre/scriptextensions/src/bee7ff30d941ed7605e7ea15ba4a5041582778e6/SQLUtilities/README.MD?at=default&fileviewer=file-view-default
I can't run it (because there is an error at the first line ?).
I choose VBScript as the language to be used for scripting. Maybe this is incorrect? What language is your example in?
Please advice.
- mgroen2Super Contributor
Ok, I installed the script extension.
Now, I don't have any clue what to do next? How to write a simple code to make use of the freshly installed Script extension?
Please remember I am new to this and my main objective is to perform a validation on an SQL database using paremetrized (dynamically) parts in the "WHERE" clausules of the SQL statements..
- tristaanogreEsteemed Contributor
This is a script extension...
https://support.smartbear.com/testcomplete/docs/working-with/extending/script/installing-and-uninstalling.html - mgroen2Super Contributor
I downloaded the .tcx file.
How to install it? Using File -> Install extensions?
If I do that, I get this error:
- tristaanogreEsteemed Contributor
https://bitbucket.org/privateteamogre/scriptextensions/downloads/SQLUtilities.tcx
I think you can get to the read me at https://bitbucket.org/privateteamogre/scriptextensions/src/bee7ff30d941ed7605e7ea15ba4a5041582778e6/SQLUtilities/README.MD?at=default&fileviewer=file-view-default. Let me know if that doesn't work and I'll PM you the info.
- mgroen2Super Contributortristaanogre where can I find/download the extension?
- tristaanogreEsteemed Contributor
The extension is available and usable now as it is to simply run the SQL query and retrieve the resulting record set. The only thing missing is the "Checkpoint" functionality. So... feel free to download and utilize it as is...
Related Content
- 3 years ago
- 5 years ago
- 13 years ago
- 5 years ago