13 Comments
- tristaanogreEsteemed Contributor
I've +1 this item. In the meantime, I'm going to add the "check" function to my SQLUtilities extension to do the kind of comparison you are asking. No guarentee as to when that will be done but it is a very good idea.
- mgroen2Super Contributor
tristaanogre Thanks, please keep me posted as I'd like to use/test your feature if/when it's available.
Also, as a 'workaround' I am going to try to work with the ADO Create Command, as suggested in the thread this feature request is reffering to. I will keep you posted.
- 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...
- mgroen2Super Contributortristaanogre where can I find/download the extension?
- 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 Contributor
I downloaded the .tcx file.
How to install it? Using File -> Install extensions?
If I do that, I get this error:
- tristaanogreEsteemed Contributor
This is a script extension...
https://support.smartbear.com/testcomplete/docs/working-with/extending/script/installing-and-uninstalling.html - 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..
- 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.
Related Content
- 3 years ago
- 13 years ago
- 5 years ago
- 5 years ago