Invoke Action in Microsoft SQL Management Studio

Ask general questions here.
ElSticky
Posts: 34
Joined: Tue Sep 17, 2013 1:45 pm

Invoke Action in Microsoft SQL Management Studio

Post by ElSticky » Mon Sep 23, 2013 9:05 am

Currently I'm trying to use SQL Management Studio to validate a value in our database. So i've recorded a few steps in Ranorex to run the Management Studio and go into the correct folder where the stored procedures are etc.

The item (stored procedure) I want to click is in the Object Explorer of the Management Studio but it is not viewable. You would have to scroll to find the item. So I thought about using an Invoke Action Select but this one does not find the item in the list.

Is there another way or do you really have to use a scroll action?

krstcs
Ranorex Guru
Posts: 2683
Joined: Tue Feb 07, 2012 4:14 pm
Location: Austin, Texas, USA

Re: Invoke Action in Microsoft SQL Management Studio

Post by krstcs » Tue Sep 24, 2013 2:28 pm

Are you validating the MSSQL Stored Procedure (SP) itself, or are you using the SP to validate an item in your SUT?

You say you are validating a value in the DB, but then go on to talk about the SP, so not sure exactly what you are trying to do.

If the first, can you not just call the SP from .NET code in your test and check that the results are correct?

If the second, can you not just call the SP from .NET code in your test (see a pattern here? :D) and check that the results match the SUT?


You can create a SQL data connector in Ranorex and call the SP from there, which would be the easiest way, if you don't need any special processing or parameterization of the SQL statement.
Shortcuts usually aren't...

ElSticky
Posts: 34
Joined: Tue Sep 17, 2013 1:45 pm

Re: Invoke Action in Microsoft SQL Management Studio

Post by ElSticky » Thu Oct 10, 2013 12:55 pm

I wrote some .NET code and it works now, thanks for the tip :)