Toad World® Forums

Code Complete comments and question


#1

Below is a table with a few Code complete questions and comments. (Some could be
bugs) More will be sent later this week. Just getting going with the new beta…

Please remember, my job now is not necessarily being a SQL programmer, except
when there are strange issues. Such is the life of a SS DBA/Archtitect.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary

Issues

Graphic

Comments/Actions

Please advise when typing in the shown statement the built in function list is
displayed… What is needed here is nothing at all for this is a select * into
statement being constructed.

The Editor should not show the functions list after you type in a schema name of
dbo… This does not happen if you type in hfdbo. Which does not exist.

If this was a select * Into and the next character is an ‘@’ then
the list to the left in the graphic would be valid and useful.

As you can see the second example when you perform a Select * into #HF_test
followed by a space you get the function list AGAIN.

Therefore, I consider this nuisance as such and a BUG !!!

When working with Code Complete to find issues with simple select statements.
Toad-SS goes into a loop that completely takes over the I5-quad core CPU.

Code complete is still a very large issue when trying to use it with simple
statements as seen in the graphic to the left.

I was never able to complete the statement because of the Toad-SS Beta program
issue (looping is suspected)

The means to correct the problem was to shutdown Toad-SS. This should be
relatively easy to reproduce since I could easily do it again and again.
Therefore, No Support Bundle supplied.

While editing an Update statement Code Complete displays the options as seen in
the graph. When all I was trying to do was drop and drag a table from the Object
explorer.

This level of functionality is not fully understood, could this be explained why
I get the options, when I do not need it.

Seems to be a timing issue for it doesn’t happen all the time, but it does
happen … Granted the fully qualified database name need to be in [ ], but I
wanted the system to find that error, which it did. Sooo, that may be the reason
for the error.

image001.gif

image002.jpeg

image004.jpeg

image006.png

image008.png

image009.jpeg

image011.png

image012.png

image013.png

image014.png


#2

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image004.png


#3

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image001.jpeg


#4

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image012.png


#5

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image013.png


#6

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image002.jpeg


#7

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image005.png


#8

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image001.gif


#9

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image001.jpeg


#10

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image003.jpeg


#11

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image011.png


#12

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image015.jpeg


#13

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image006.jpeg


#14

Hello Hank,

Thank you for your input. Some answers below:

Attachment not added (too many attachments): “image018.jpg”
Attachment not added (too many attachments): “image020.jpg”
image014.png


#15

Regarding item #2, is it possible to cache the object list locally so that even
if you have a large number of items, it only has to do this once and then when
needed, to pull the list of object from the local list of objects for faster or
instant results? Then have a way to refresh the cache as needed?
image013.png


#16

Regarding item #2, is it possible to cache the object list locally so that even
if you have a large number of items, it only has to do this once and then when
needed, to pull the list of object from the local list of objects for faster or
instant results? Then have a way to refresh the cache as needed?
image013.jpeg


#17

Regarding item #2, is it possible to cache the object list locally so that even
if you have a large number of items, it only has to do this once and then when
needed, to pull the list of object from the local list of objects for faster or
instant results? Then have a way to refresh the cache as needed?
image014.png


#18

Regarding item #2, is it possible to cache the object list locally so that even
if you have a large number of items, it only has to do this once and then when
needed, to pull the list of object from the local list of objects for faster or
instant results? Then have a way to refresh the cache as needed?
image006.jpeg


#19

Regarding item #2, is it possible to cache the object list locally so that even
if you have a large number of items, it only has to do this once and then when
needed, to pull the list of object from the local list of objects for faster or
instant results? Then have a way to refresh the cache as needed?
image012.png


#20

Regarding item #2, is it possible to cache the object list locally so that even
if you have a large number of items, it only has to do this once and then when
needed, to pull the list of object from the local list of objects for faster or
instant results? Then have a way to refresh the cache as needed?
image002.jpeg