Recognition of different SQL Management versions

Ask general questions here.
leon
Posts: 14
Joined: Fri Jul 22, 2011 8:12 am

Recognition of different SQL Management versions

Post by leon » Tue Aug 16, 2011 8:58 am

I am struggling to have 1 set script running for identifying, recognising or selecting items in the tree in the different versions of SQL Management Studio.

Eg:
The Object Explorer of SQL Server2008R2 is mapped as : container[@caption='Object Explorer']/container[@caption='']/tree/tree/treeitem/treeitem[@accessiblename='Security'] level and

SQL Server 2008 is mapped as: container[@caption='Object Explorer']/container[@caption='']/container/tree/tree/treeitem/treeitem[@accessiblename='Security'] and extra level = container. The 2 versions are thus not mapped the same.

How do I get around this without so many "continue fail" actions because when I have to validate if a certain Login user has been created the one fails and the one passes due to this problem which results in my script showing a Fail

User avatar
sdaly
Posts: 238
Joined: Mon May 10, 2010 11:04 am
Location: Dundee, Scotland

Re: Recognition of different SQL Management versions

Post by sdaly » Tue Aug 16, 2011 10:26 am

Use a double forward slash in your path //

User avatar
Support Team
Site Admin
Site Admin
Posts: 11710
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: Recognition of different SQL Management versions

Post by Support Team » Tue Aug 16, 2011 10:29 am

Hi,
leon wrote:How do I get around this without so many "continue fail" actions because when I have to validate if a certain Login user has been created the one fails and the one passes due to this problem which results in my script showing a Fail
As scott suggested you can use a relative RxPath. I would suggest you to read following blog
http://www.ranorex.com/blog/ranorexpath-tips-and-tricks
In this blog will be explained what's possible with the RxPath.

In Ranorex 3.1 there will be a setting to change the Report Level for the "Continue on Fail" action. Then you can set the Report Level to Success even the Test Case failed.

Regards,
Peter
Ranorex Team
.
Image

leon
Posts: 14
Joined: Fri Jul 22, 2011 8:12 am

Re: Recognition of different SQL Management versions

Post by leon » Tue Aug 16, 2011 11:03 am

Aah thx Scott, you're a star. Seems to be working now.