Red Gate forums :: View topic - Result window not scrolled to correct position
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Search 2
SQL Search 2 forum

Result window not scrolled to correct position

Search in SQL Search 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
KevinGreiner



Joined: 05 Mar 2012
Posts: 21
Location: United States

PostPosted: Wed Apr 30, 2014 11:59 am    Post subject: Result window not scrolled to correct position Reply with quote

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.
Back to top
View user's profile Send private message
jimVisage1980



Joined: 02 May 2014
Posts: 4

PostPosted: Fri May 02, 2014 12:01 pm    Post subject: Me too. Reply with quote

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.
Back to top
View user's profile Send private message
jcat



Joined: 14 Feb 2011
Posts: 6

PostPosted: Fri May 09, 2014 6:05 pm    Post subject: Experiencing this as well Reply with quote

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
Back to top
View user's profile Send private message
dreadfulishan



Joined: 13 May 2014
Posts: 1

PostPosted: Tue May 13, 2014 4:08 pm    Post subject: Same prolem, too Reply with quote

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.
Back to top
View user's profile Send private message
kevriley



Joined: 07 Apr 2009
Posts: 70
Location: UK

PostPosted: Thu May 15, 2014 1:59 pm    Post subject: Reply with quote

Just to add I'm experiencing the same issue.

SSMS 2008R2
Win7

and
SSMS 2012
Win7
Back to top
View user's profile Send private message
dom.smith



Joined: 03 Jun 2010
Posts: 94
Location: Cambridge, UK

PostPosted: Fri May 16, 2014 3:23 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
jimVisage1980



Joined: 02 May 2014
Posts: 4

PostPosted: Fri May 16, 2014 3:28 pm    Post subject: Feedback as requested Reply with quote

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
Back to top
View user's profile Send private message
kevriley



Joined: 07 Apr 2009
Posts: 70
Location: UK

PostPosted: Fri May 16, 2014 4:00 pm    Post subject: Reply with quote

I've noticed it on fairly long stored procedures. Let me see if I can get an example.
Back to top
View user's profile Send private message
jimVisage1980



Joined: 02 May 2014
Posts: 4

PostPosted: Fri May 16, 2014 4:18 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
kevriley



Joined: 07 Apr 2009
Posts: 70
Location: UK

PostPosted: Fri May 16, 2014 4:26 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
dom.smith



Joined: 03 Jun 2010
Posts: 94
Location: Cambridge, UK

PostPosted: Tue May 20, 2014 2:56 pm    Post subject: Reply with quote

Thanks, we'll look into that.
_________________
Dominic Smith,
Project Manager,
Red Gate Software.
Back to top
View user's profile Send private message
jimVisage1980



Joined: 02 May 2014
Posts: 4

PostPosted: Wed Jun 18, 2014 9:25 am    Post subject: Any progress? Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group