Toad World® Forums

Casing for Auto Complete


#1

I just installed the latest beta build and noticed it auto completes variable
types when I do a DECLARE). This is really nice, except, I like all my
variable type declarations in upper case and when I type it in upper case and
hit enter, it finds the variable type match but converts it to lower case. I
have the option set in auto-complete to leave casing as it is, but it seems to
be ignoring this.

Thanks,


Charles Haines
Senior Software Developer
P: (410) 535-5590 x1196

Recorded Books, LLC
http://www.recorded books.com


#2

Charles,

Exactly what part of the statement is not getting the proper case? Can you reply
with the sample statement and highlight the text that is not converting to upper
case?

Thanks,

David


#3

David, I am experiencing the same set of issues and have sent in a Support
Bundle earlier today.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary
image001.gif


#4

David, I am experiencing the same set of issues and have sent in a Support
Bundle earlier today.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary
image002.jpeg


#5

I’m not sure what good a support bundle would do in this case –
Charles is not reporting a bug or crash but rather part of his statement did not
change case as expected. We need to know exactly what part of the statement he
expected to change case that did not.
image002.jpeg


#6

I’m not sure what good a support bundle would do in this case –
Charles is not reporting a bug or crash but rather part of his statement did not
change case as expected. We need to know exactly what part of the statement he
expected to change case that did not.
image001.gif


#7

Hank,

Are you talking about

SQL Editor session faults on syntax to Set a local variable when the @ value is
typed

and

Toad-SS-Beta- 414 Faults on simpel copy and paste

?

If yes, then the issue Charles is describing seems different. Or did I missed
something?

Igor.
image002.jpeg


#8

Hank,

Are you talking about

SQL Editor session faults on syntax to Set a local variable when the @ value is
typed

and

Toad-SS-Beta- 414 Faults on simpel copy and paste

?

If yes, then the issue Charles is describing seems different. Or did I missed
something?

Igor.
image001.gif


#9

Igor, I am having both issue.

I sometimes getting the problem that Charles is getting, but I am also not
getting past the DECLARE @ … Where I want to type DECLARE @DB_NAME sysname
….

So we have both issues. Sorry for the confusion.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary
image001.gif


#10

Igor, I am having both issue.

I sometimes getting the problem that Charles is getting, but I am also not
getting past the DECLARE @ … Where I want to type DECLARE @DB_NAME sysname
….

So we have both issues. Sorry for the confusion.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary
image002.jpeg


#11

So for example what I really want in the editor is the following line

DECLARE @VarName DATETIME

However when I type the above line it, it matches the DATETIME to an
autocomplete and the following is actually the line that is produced

DECLARE @VarName datetime

I want the DATETIME to remain in upper case and I keep all my variable type
definition is upper case.

Thanks,


Charles Haines
Senior Software Developer
P: (410) 535-5590 x1196

Recorded Books, LLC
http://www.recorded books.com

On Wed, Jun 16, 2010 at 6:52 PM, Hank Freeman MSN wrote:

Igor, I am having both issue.

 

I sometimes getting the problem that Charles is getting, but I am also not
getting past the DECLARE  @  … Where I want to type DECLARE @DB_NAME
sysname ….

 

So we have both issues. Sorry for the confusion.

 

 

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary

image002.jpeg


#12

So for example what I really want in the editor is the following line

DECLARE @VarName DATETIME

However when I type the above line it, it matches the DATETIME to an
autocomplete and the following is actually the line that is produced

DECLARE @VarName datetime

I want the DATETIME to remain in upper case and I keep all my variable type
definition is upper case.

Thanks,


Charles Haines
Senior Software Developer
P: (410) 535-5590 x1196

Recorded Books, LLC
http://www.recorded books.com

On Wed, Jun 16, 2010 at 6:52 PM, Hank Freeman MSN wrote:

Igor, I am having both issue.

 

I sometimes getting the problem that Charles is getting, but I am also not
getting past the DECLARE  @  … Where I want to type DECLARE @DB_NAME
sysname ….

 

So we have both issues. Sorry for the confusion.

 

 

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary

image001.gif


#13

There are more basic issues with code compete than casing.

Code complete does not work for items outside of the database you have selected.
I write all code by hand and the code is wrote so that it does not matter what
database I have selected to be able to run it. I normally open the editor which
is defaulted to Master and I leave it there and start typing code.

Example below. I have opened Toad, it is defaulted to Master and I want to start
typing some code. I am going to write code for the alliance_website database.

I type “select *”, and press enter (for line break), type
“from” and a space and I wait for the code complete to pop up. I
start typing “allia” and nothing shows up. There is no list of
database objects which should be part of this list. They are not there.

Here is how it should display

Also, I have notice something weird with the Toad GUI. If I have the bubble help
(in the first screen it would be the “all_columns” in yellow) and
leave it showing and go to a different application, the bubble help will stay on
top no matter what application I open. So I left the bubble help as you see it
in the first screen and I went to Outlook and you can still see it on top of
Outlook.

Another thing I noticed regarding dual monitors. If I open toad on the left
monitor and then move toad to the right monitor, any dialog boxes will open on
the left monitor. If you open toad and keep it on the monitor it opened on, the
dialog boxes will open on that monitor. They should open on the monitor that
Toad is located on.

Toad does correctly stay on the monitor on which you closed toad. So if I open
toad on the right monitor, move it to the left, close toad, it opens on the left
when I open it again.

Thanks,

Matt
image002.jpeg


#14

There are more basic issues with code compete than casing.

Code complete does not work for items outside of the database you have selected.
I write all code by hand and the code is wrote so that it does not matter what
database I have selected to be able to run it. I normally open the editor which
is defaulted to Master and I leave it there and start typing code.

Example below. I have opened Toad, it is defaulted to Master and I want to start
typing some code. I am going to write code for the alliance_website database.

I type “select *”, and press enter (for line break), type
“from” and a space and I wait for the code complete to pop up. I
start typing “allia” and nothing shows up. There is no list of
database objects which should be part of this list. They are not there.

Here is how it should display

Also, I have notice something weird with the Toad GUI. If I have the bubble help
(in the first screen it would be the “all_columns” in yellow) and
leave it showing and go to a different application, the bubble help will stay on
top no matter what application I open. So I left the bubble help as you see it
in the first screen and I went to Outlook and you can still see it on top of
Outlook.

Another thing I noticed regarding dual monitors. If I open toad on the left
monitor and then move toad to the right monitor, any dialog boxes will open on
the left monitor. If you open toad and keep it on the monitor it opened on, the
dialog boxes will open on that monitor. They should open on the monitor that
Toad is located on.

Toad does correctly stay on the monitor on which you closed toad. So if I open
toad on the right monitor, move it to the left, close toad, it opens on the left
when I open it again.

Thanks,

Matt
image004.png


#15

There are more basic issues with code compete than casing.

Code complete does not work for items outside of the database you have selected.
I write all code by hand and the code is wrote so that it does not matter what
database I have selected to be able to run it. I normally open the editor which
is defaulted to Master and I leave it there and start typing code.

Example below. I have opened Toad, it is defaulted to Master and I want to start
typing some code. I am going to write code for the alliance_website database.

I type “select *”, and press enter (for line break), type
“from” and a space and I wait for the code complete to pop up. I
start typing “allia” and nothing shows up. There is no list of
database objects which should be part of this list. They are not there.

Here is how it should display

Also, I have notice something weird with the Toad GUI. If I have the bubble help
(in the first screen it would be the “all_columns” in yellow) and
leave it showing and go to a different application, the bubble help will stay on
top no matter what application I open. So I left the bubble help as you see it
in the first screen and I went to Outlook and you can still see it on top of
Outlook.

Another thing I noticed regarding dual monitors. If I open toad on the left
monitor and then move toad to the right monitor, any dialog boxes will open on
the left monitor. If you open toad and keep it on the monitor it opened on, the
dialog boxes will open on that monitor. They should open on the monitor that
Toad is located on.

Toad does correctly stay on the monitor on which you closed toad. So if I open
toad on the right monitor, move it to the left, close toad, it opens on the left
when I open it again.

Thanks,

Matt


#16

There are more basic issues with code compete than casing.

Code complete does not work for items outside of the database you have selected.
I write all code by hand and the code is wrote so that it does not matter what
database I have selected to be able to run it. I normally open the editor which
is defaulted to Master and I leave it there and start typing code.

Example below. I have opened Toad, it is defaulted to Master and I want to start
typing some code. I am going to write code for the alliance_website database.

I type “select *”, and press enter (for line break), type
“from” and a space and I wait for the code complete to pop up. I
start typing “allia” and nothing shows up. There is no list of
database objects which should be part of this list. They are not there.

Here is how it should display

Also, I have notice something weird with the Toad GUI. If I have the bubble help
(in the first screen it would be the “all_columns” in yellow) and
leave it showing and go to a different application, the bubble help will stay on
top no matter what application I open. So I left the bubble help as you see it
in the first screen and I went to Outlook and you can still see it on top of
Outlook.

Another thing I noticed regarding dual monitors. If I open toad on the left
monitor and then move toad to the right monitor, any dialog boxes will open on
the left monitor. If you open toad and keep it on the monitor it opened on, the
dialog boxes will open on that monitor. They should open on the monitor that
Toad is located on.

Toad does correctly stay on the monitor on which you closed toad. So if I open
toad on the right monitor, move it to the left, close toad, it opens on the left
when I open it again.

Thanks,

Matt
image001.jpeg


#17

There are more basic issues with code compete than casing.

Code complete does not work for items outside of the database you have selected.
I write all code by hand and the code is wrote so that it does not matter what
database I have selected to be able to run it. I normally open the editor which
is defaulted to Master and I leave it there and start typing code.

Example below. I have opened Toad, it is defaulted to Master and I want to start
typing some code. I am going to write code for the alliance_website database.

I type “select *”, and press enter (for line break), type
“from” and a space and I wait for the code complete to pop up. I
start typing “allia” and nothing shows up. There is no list of
database objects which should be part of this list. They are not there.

Here is how it should display

Also, I have notice something weird with the Toad GUI. If I have the bubble help
(in the first screen it would be the “all_columns” in yellow) and
leave it showing and go to a different application, the bubble help will stay on
top no matter what application I open. So I left the bubble help as you see it
in the first screen and I went to Outlook and you can still see it on top of
Outlook.

Another thing I noticed regarding dual monitors. If I open toad on the left
monitor and then move toad to the right monitor, any dialog boxes will open on
the left monitor. If you open toad and keep it on the monitor it opened on, the
dialog boxes will open on that monitor. They should open on the monitor that
Toad is located on.

Toad does correctly stay on the monitor on which you closed toad. So if I open
toad on the right monitor, move it to the left, close toad, it opens on the left
when I open it again.

Thanks,

Matt
image001.jpeg


#18

There are more basic issues with code compete than casing.

Code complete does not work for items outside of the database you have selected.
I write all code by hand and the code is wrote so that it does not matter what
database I have selected to be able to run it. I normally open the editor which
is defaulted to Master and I leave it there and start typing code.

Example below. I have opened Toad, it is defaulted to Master and I want to start
typing some code. I am going to write code for the alliance_website database.

I type “select *”, and press enter (for line break), type
“from” and a space and I wait for the code complete to pop up. I
start typing “allia” and nothing shows up. There is no list of
database objects which should be part of this list. They are not there.

Here is how it should display

Also, I have notice something weird with the Toad GUI. If I have the bubble help
(in the first screen it would be the “all_columns” in yellow) and
leave it showing and go to a different application, the bubble help will stay on
top no matter what application I open. So I left the bubble help as you see it
in the first screen and I went to Outlook and you can still see it on top of
Outlook.

Another thing I noticed regarding dual monitors. If I open toad on the left
monitor and then move toad to the right monitor, any dialog boxes will open on
the left monitor. If you open toad and keep it on the monitor it opened on, the
dialog boxes will open on that monitor. They should open on the monitor that
Toad is located on.

Toad does correctly stay on the monitor on which you closed toad. So if I open
toad on the right monitor, move it to the left, close toad, it opens on the left
when I open it again.

Thanks,

Matt
image001.gif


#19

There are more basic issues with code compete than casing.

Code complete does not work for items outside of the database you have selected.
I write all code by hand and the code is wrote so that it does not matter what
database I have selected to be able to run it. I normally open the editor which
is defaulted to Master and I leave it there and start typing code.

Example below. I have opened Toad, it is defaulted to Master and I want to start
typing some code. I am going to write code for the alliance_website database.

I type “select *”, and press enter (for line break), type
“from” and a space and I wait for the code complete to pop up. I
start typing “allia” and nothing shows up. There is no list of
database objects which should be part of this list. They are not there.

Here is how it should display

Also, I have notice something weird with the Toad GUI. If I have the bubble help
(in the first screen it would be the “all_columns” in yellow) and
leave it showing and go to a different application, the bubble help will stay on
top no matter what application I open. So I left the bubble help as you see it
in the first screen and I went to Outlook and you can still see it on top of
Outlook.

Another thing I noticed regarding dual monitors. If I open toad on the left
monitor and then move toad to the right monitor, any dialog boxes will open on
the left monitor. If you open toad and keep it on the monitor it opened on, the
dialog boxes will open on that monitor. They should open on the monitor that
Toad is located on.

Toad does correctly stay on the monitor on which you closed toad. So if I open
toad on the right monitor, move it to the left, close toad, it opens on the left
when I open it again.

Thanks,

Matt
image002.jpeg


#20

Matt,

Click the button at the bottom of the code-completion list to “merge
secondary items” and then you will be able to pick from a different
database. Let me know if this helps.

Thanks,

David
image004.png