Implement support for validation on Database tables using dynamical values in WHERE clausule (SQL)

marinThis feature request is based on an original question from you. Maybe you can give it a vote?

 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.

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.

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...  

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.

I downloaded the .tcx file.

How to install it? Using File -> Install extensions?

If I do that, I get this error:

This is a script extension... 

https://support.smartbear.com/testcomplete/docs/working-with/extending/script/installing-and-uninstalling.html

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..

tristaanogre

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.