| Author |
Message |
Oliwa
Joined: 11 Jan 2007
Posts: 28
|
 Posted: Wed Aug 11, 2010 5:53 pm Post subject: GO capitalization issues |
 |
|
| GO never seems to capitalize. If I type "g" and hit ENTER or TAB it capitalizes...but not if I type the word "go" and then hit ENTER. This is odd because it works with other keywords. |
|
| Back to top |
|
 |
chriskelly
Joined: 19 Apr 2010
Posts: 253
Location: Cambridge, UK
|
| Posted: Thu Aug 12, 2010 6:46 pm Post subject: |
|
|
| Can you go to the SQL Prompt Options (through the SQL Prompt menu) and look at the Format->Case page. Are all the options set to UPPERCASE? |
|
| Back to top |
|
|
Oliwa
Joined: 11 Jan 2007
Posts: 28
|
| Posted: Thu Aug 12, 2010 11:25 pm Post subject: |
|
|
Yes, all options are set to uppercase. All other keywords capitalize as expected. If I type a "g" and hit ENTER it inserts "GO", and if I type "select" and hit TAB it capitalizes, but not "g".
And I have TAB and ENTER set as activation keys. |
|
| Back to top |
|
|
chriskelly
Joined: 19 Apr 2010
Posts: 253
Location: Cambridge, UK
|
| Posted: Fri Aug 13, 2010 9:53 am Post subject: |
|
|
Through some limited testing I have found that this seems to happen when the preceding statement has not been terminated by a semi-colon ( .
for example:
SELECT * FROM Person.Address
go
would instead come out as:
SELECT * FROM Person.Address;
GO
is this the case with your situation? |
|
| Back to top |
|
|
Oliwa
Joined: 11 Jan 2007
Posts: 28
|
| Posted: Fri Aug 13, 2010 4:21 pm Post subject: |
|
|
| I tried what you suggested and whenever I had very simple scripts the capitalization worked fine, but I know I have scripts where "go" doesn't capitalize. I will respond with more information when I encounter the behavior again. |
|
| Back to top |
|
|
Oliwa
Joined: 11 Jan 2007
Posts: 28
|
| Posted: Fri Aug 20, 2010 7:35 pm Post subject: |
|
|
I think I found a reproducible scenario...
This is just one of the scenarios I found where go is not capitalized. There are others, but sometimes they work and other times not.
If I declare a variable and type go afterward it capitalizes like so...
| Code: |
DECLARE @var INT;{ENTER}
go{ENTER}
|
Now if I try putting in a USE statement before or after the batch go does not capitalize...
| Code: |
USE master;{ENTER}
go{ENTER}
DECLARE @var INT;
GO
USE master;{ENTER}
go{ENTER}
|
But if I type "g" and hit ENTER it works. |
|
| Back to top |
|
|
chriskelly
Joined: 19 Apr 2010
Posts: 253
Location: Cambridge, UK
|
| Posted: Mon Aug 23, 2010 3:09 pm Post subject: |
|
|
To begin with when I tried to reproduce your example all of the 'go's capitalised as it should.
However, I tried creating a new stored procedure to see if one named with 'go' could affect sql prompt. I named mine 'go_home' containing a very simple select statement. After creating it, I retried your example and that was when I got the results that you describe.
Can you confirm for me whether you have a stored procedure (or any other object) that could be interfering in this way? If you do, can you try dropping it and then re-testing your example. Do you get the same results? |
|
| Back to top |
|
|
Oliwa
Joined: 11 Jan 2007
Posts: 28
|
| Posted: Tue Aug 24, 2010 8:19 pm Post subject: |
|
|
| I do not have any objects starting with "go". Next time it happens I'll see if there is any objects named similarly. |
|
| Back to top |
|
|
|
