Result window not scrolled to correct position

A free Management Studio add-in to search for SQL in your databases

Moderator: dom.smith

Result window not scrolled to correct position

Postby KevinGreiner » Wed Apr 30, 2014 11:59 am

I just installed SQL Search v2, upgrading from v1. It looks quite different but nice, especially the selection of multiple databases.

When scrolling through search results, I noticed the bottom results window was moved to a position in the middle of the script. But no yellow highlighted text was displayed. I have to scroll the results window up 5-10 lines to see the highlighted text.

This is consistent across multiple searches and multiple search results.

Using Windows 8.1 and multiple monitors.
KevinGreiner
 
Posts: 21
Joined: Mon Mar 05, 2012 9:38 pm
Location: United States

Me too.

Postby jimVisage1980 » Fri May 02, 2014 12:01 pm

I'm getting the same problem SSMS 2008 R2 and Windows 7

Shame really as all the other changes are most welcome but not jumping to the search term is a real pain.

Please fix Redgate and many thanks for this most useful of free tools.
jimVisage1980
 
Posts: 4
Joined: Fri May 02, 2014 11:57 am

Experiencing this as well

Postby jcat » Fri May 09, 2014 6:05 pm

Yep, same problem here. I didn't notice at first because a couple of my searches returned very short code that fit in the results window, but with longer code results it never scrolls to the correct (matching code text) position.

I'm sure it'll get fixed soon, but for now it's really frustrating. I love the fact that they finally fixed it so we can copy from the results window - that's huge. For that plus searching through Jobs as well I'll stick with this version and hope for a fix to the scroll problem in the near future.

EDIT: wanted to add my environment in case it's helpful for the devs.

SSMS 2012
Windows 8 x64
Last edited by jcat on Thu May 15, 2014 4:48 pm, edited 1 time in total.
jcat
 
Posts: 6
Joined: Mon Feb 14, 2011 7:04 pm

Same prolem, too

Postby dreadfulishan » Tue May 13, 2014 4:08 pm

Hey everyone I am getting the same problem, too. Maybe they would notice this and fix it up in the next minor update.
C, C++, Java, HTML & css, php everything is fun.
dreadfulishan
 
Posts: 1
Joined: Tue May 13, 2014 3:53 pm

Postby kevriley » Thu May 15, 2014 1:59 pm

Just to add I'm experiencing the same issue.

SSMS 2008R2
Win7

and
SSMS 2012
Win7
kevriley
 
Posts: 71
Joined: Tue Apr 07, 2009 12:46 pm
Location: UK

Postby dom.smith » Fri May 16, 2014 3:23 pm

Hi everyone,

Thanks for the feedback. We're really interested in this bug, as we spent a long time trying to get the highlighting and scrolling right, and it sounds like we haven't quite solved it after all.

It would be really useful if you could give examples of specific searches that aren't being highlighted, along with the relevant parts of the schema you're searching against. If you'd prefer not to send them in a public forum, feel free to DM me, and I'll pass your examples to the team.

Thanks,
Dom.
Dominic Smith,
Project Manager,
Red Gate Software.
dom.smith
 
Posts: 98
Joined: Thu Jun 03, 2010 5:54 pm
Location: Cambridge, UK

Feedback as requested

Postby jimVisage1980 » Fri May 16, 2014 3:28 pm

Hi there Dom,

In my case the problem happens for all searches and I specifically see the problem for match of text in db object type stored procedure or function.

Thanks
Jim
jimVisage1980
 
Posts: 4
Joined: Fri May 02, 2014 11:57 am

Postby kevriley » Fri May 16, 2014 4:00 pm

I've noticed it on fairly long stored procedures. Let me see if I can get an example.
kevriley
 
Posts: 71
Joined: Tue Apr 07, 2009 12:46 pm
Location: UK

Postby jimVisage1980 » Fri May 16, 2014 4:18 pm

I've got a 44 line stored proc and the jump to found text works ok.
A stored proc of more lines and the jump to doesn't work.

I don't know the exact cut-off but an SP of 96 lines definitely causes issues
jimVisage1980
 
Posts: 4
Joined: Fri May 02, 2014 11:57 am

Postby kevriley » Fri May 16, 2014 4:26 pm

Here's an example using AdventureWorks2008 or AdventureWorks2008R2 or AdventureWorks2012.

Search for the text 'proc'. Click on the result 'uspGetBillOfMaterials'

Display pane scrolls down the proc, away from the highlighted obvious 'proc' in the first line.
kevriley
 
Posts: 71
Joined: Tue Apr 07, 2009 12:46 pm
Location: UK

Postby dom.smith » Tue May 20, 2014 2:56 pm

Thanks, we'll look into that.
Dominic Smith,
Project Manager,
Red Gate Software.
dom.smith
 
Posts: 98
Joined: Thu Jun 03, 2010 5:54 pm
Location: Cambridge, UK

Any progress?

Postby jimVisage1980 » Wed Jun 18, 2014 9:25 am

Hi guys,
Any movement in fixing this problem?

Must admit that for me all the new features in version 2 have been negated by the inability to jump to the highlighted line in the results screen.

I'll probably revert to version 1 in the meantime.

Cheers for a great FREE tool. Efforts are appreciated.
Jim
jimVisage1980
 
Posts: 4
Joined: Fri May 02, 2014 11:57 am


Return to SQL Search 2

Who is online

Users browsing this forum: No registered users and 0 guests