SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
BUG Cursor Jumps
Goto page 1, 2  Next
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
BUG Cursor Jumps
Author Message
giggles220



Joined: 01 Dec 2006
Posts: 22
Country: USA NY

Post BUG Cursor Jumps Reply with quote
I type in a query select * from tablename. I then want to edit it to select top 10 * from tablename.

When I type the work top and then the space It jumps to the end of my query moving the top keyword with it resulting in SELECT * FROM tablenameTOP
Fri Dec 01, 2006 3:27 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
Sorry I am unable to reproduce it. Which editor do you use?
Fri Dec 01, 2006 4:02 pm View user's profile Send private message
giggles220



Joined: 01 Dec 2006
Posts: 22
Country: USA NY

Post Reply with quote
SQL Management Studio 9.00.2047.00

This still happens with version 1.0.46 of the product.
Fri Dec 01, 2006 4:04 pm View user's profile Send private message
giggles220



Joined: 01 Dec 2006
Posts: 22
Country: USA NY

Post Reply with quote
This still happens in 1.0.47 but I also tried differeing where I placed the top keyword ( after select or right before the * ) and I noticed that if I put the cursor after the word select and press space it moves the select keyword to the end of the query turning select * from tablename to * from tablename select
Tue Dec 05, 2006 10:16 am View user's profile Send private message
giggles220



Joined: 01 Dec 2006
Posts: 22
Country: USA NY

Post Reply with quote
Are there plans to fix this??? It is very annoying and apparently it doesn't matter where in a query I am editting. if I press space it moves whatever was just inserted to the end. It is getting annoying to have to suspend SQLAssistant to edit my queries and turn them back on when I am done.
Thu Dec 07, 2006 1:44 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
We are trying to reproduce that, but so far unsuccessful. Here is what really should happen.

Perhaps, you have

SELECT * FROM tablenam

You click after SELECT and press SPACE key you should get
SELECT <popup here> * FROM tablenam

and nothing should move.

Does it do the same thing if after placing cursor after SELECT keyword you press CTRL+SPACE instead of SPACE?
Thu Dec 07, 2006 2:14 pm View user's profile Send private message
giggles220



Joined: 01 Dec 2006
Posts: 22
Country: USA NY

Post Reply with quote
I understand what should happen.

I typed select * from tablename

I press ctrl+Space after the select and I get the appropriate pop up (GOOD!:))

I press just space and I get * FROM tablenameSELECT
Thu Dec 07, 2006 2:17 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
I've got several versions of the Management Studio around here but not 9.00.2047.00

In all of them, what you are describing is not happening. What do I need to install to get 9.00.2047.00? Did it come with the SP1 or some other update?

By the way, this is issue is only specific to Management Studio. Right?
Thu Dec 07, 2006 2:26 pm View user's profile Send private message
giggles220



Joined: 01 Dec 2006
Posts: 22
Country: USA NY

Post Reply with quote
I only use SSMS so I can't attest to any other areas. You need to install SP1 on your machine and then you will have 2047
Thu Dec 07, 2006 2:28 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
Well, I installed SP1. The about box in SSMS now says 9.00.2047 and no matter what I type or click in editor my cursor doesn't jump mysteriously to the end of the line moving current keyword along.

Please take a look at customizations you may have created in SSMS (Tools/Customize menu) that could be causing such anomaly, especially please check keyboard and editor settings.
Thu Dec 07, 2006 6:11 pm View user's profile Send private message
giggles220



Joined: 01 Dec 2006
Posts: 22
Country: USA NY

Post Reply with quote
I installed 1.0.49 and I removed red gates sql prompt to see if that was interferring. and the problem still happens.

I looked at the customizations and I didn't make any for keyboard and I don't see anything that would cause this issue. Are there known settings that interfer that I should change.

Any other ideas?
Fri Dec 08, 2006 8:21 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
Developers suggested to turn off the keyword reformatting feature in SQL Assistant and wait and see until somebody else can reproduce this issue.
Fri Dec 08, 2006 11:36 am View user's profile Send private message
giggles220



Joined: 01 Dec 2006
Posts: 22
Country: USA NY

Post Reply with quote
I did so and this does solve my problem. I really hope this can be reproduced at some point b/c I really like having the keyword formatted
Fri Dec 08, 2006 11:40 am View user's profile Send private message
giggles220



Joined: 01 Dec 2006
Posts: 22
Country: USA NY

Post Reply with quote
Just an update this still happens in the newest version (1.0.55).
Wed Dec 20, 2006 8:45 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
I'm still not sure what to do about it. I'm unable to reproduce it and other people don't experience this mysterious jumping. Is there anyway for you to try other editors, perhaps try Windows Wordpad to see if the jumping is specific to SSMS or happens in any program?
Wed Dec 20, 2006 9:56 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to: 
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
Design by Freestyle XL / Flowers Online.