Toad World® Forums

Toad-SS - Auto Complete does not find fields on Update or select statements when the table name is Long


#1

To the Toad-SS communities.

Please try this and let me know if I am making a mistake / completely doing
something wrong.

In either of the updates statement below the auto-complete software does not
look into the table to be updated for the field names.

If this is not a bug then please explain why!

Otherwise, please clock this issue as either a bug or a NFR, your choice.

It should be noted that Auto-Complete does not like Long table names on a SELECT
were the table name is already known, which I like to use, which maybe another
issue or par of the one I am reporting.

select (Cursor is here)

from DirectEnergy_DirectDebitInfo_TBC

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Update the Administration.dbo.DirectEnergy_DirectDebitInfo_TBC

set

use Administration

go

update DirectEnergy_DirectDebitInfo_TBC

set

image001.gif

image002.jpeg

image002.jpeg

image009.jpeg

image010.jpeg


#2

Hi Hank,

Actually I can’t reproduce your case. On my side everything looks fine for
table with very long name. It seems that this particular issue is not so simple.
I’ve tried several cases for this table “
AdventureWorksLT2008.dbo.VeryLong_table_Name_For_Testing_AutoComplete_Error
” and Code Completion works fine (listing table name, columns of this
table, using SET and UPDATE statements).

Do you still see this or it was just ones?

regards,

Alexander
image004.jpeg


#3

Hi Hank,

Actually I can’t reproduce your case. On my side everything looks fine for
table with very long name. It seems that this particular issue is not so simple.
I’ve tried several cases for this table “
AdventureWorksLT2008.dbo.VeryLong_table_Name_For_Testing_AutoComplete_Error
” and Code Completion works fine (listing table name, columns of this
table, using SET and UPDATE statements).

Do you still see this or it was just ones?

regards,

Alexander
image002.jpeg


#4

Hi Hank,

Actually I can’t reproduce your case. On my side everything looks fine for
table with very long name. It seems that this particular issue is not so simple.
I’ve tried several cases for this table “
AdventureWorksLT2008.dbo.VeryLong_table_Name_For_Testing_AutoComplete_Error
” and Code Completion works fine (listing table name, columns of this
table, using SET and UPDATE statements).

Do you still see this or it was just ones?

regards,

Alexander
image006.jpeg


#5

Hi Hank,

Actually I can’t reproduce your case. On my side everything looks fine for
table with very long name. It seems that this particular issue is not so simple.
I’ve tried several cases for this table “
AdventureWorksLT2008.dbo.VeryLong_table_Name_For_Testing_AutoComplete_Error
” and Code Completion works fine (listing table name, columns of this
table, using SET and UPDATE statements).

Do you still see this or it was just ones?

regards,

Alexander
image005.jpeg


#6

Hi Hank,

Actually I can’t reproduce your case. On my side everything looks fine for
table with very long name. It seems that this particular issue is not so simple.
I’ve tried several cases for this table “
AdventureWorksLT2008.dbo.VeryLong_table_Name_For_Testing_AutoComplete_Error
” and Code Completion works fine (listing table name, columns of this
table, using SET and UPDATE statements).

Do you still see this or it was just ones?

regards,

Alexander
image003.jpeg


#7

Hi Hank,

Actually I can’t reproduce your case. On my side everything looks fine for
table with very long name. It seems that this particular issue is not so simple.
I’ve tried several cases for this table “
AdventureWorksLT2008.dbo.VeryLong_table_Name_For_Testing_AutoComplete_Error
” and Code Completion works fine (listing table name, columns of this
table, using SET and UPDATE statements).

Do you still see this or it was just ones?

regards,

Alexander
image001.gif


#8

Alex !

get this all the time… not just a single instance.

FYI I am using an HP desktop with Windows 7-64 Pro.

I will try again to reproduce the issue. I may be able to send you the an
example database, it is small enough to send.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image006.jpeg


#9

Alex !

get this all the time… not just a single instance.

FYI I am using an HP desktop with Windows 7-64 Pro.

I will try again to reproduce the issue. I may be able to send you the an
example database, it is small enough to send.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image003.jpeg


#10

Alex !

get this all the time… not just a single instance.

FYI I am using an HP desktop with Windows 7-64 Pro.

I will try again to reproduce the issue. I may be able to send you the an
example database, it is small enough to send.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image002.jpeg


#11

Alex !

get this all the time… not just a single instance.

FYI I am using an HP desktop with Windows 7-64 Pro.

I will try again to reproduce the issue. I may be able to send you the an
example database, it is small enough to send.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image001.gif


#12

Alex !

get this all the time… not just a single instance.

FYI I am using an HP desktop with Windows 7-64 Pro.

I will try again to reproduce the issue. I may be able to send you the an
example database, it is small enough to send.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image004.jpeg


#13

Alex !

get this all the time… not just a single instance.

FYI I am using an HP desktop with Windows 7-64 Pro.

I will try again to reproduce the issue. I may be able to send you the an
example database, it is small enough to send.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image002.jpeg


#14

Alex !

get this all the time… not just a single instance.

FYI I am using an HP desktop with Windows 7-64 Pro.

I will try again to reproduce the issue. I may be able to send you the an
example database, it is small enough to send.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image005.jpeg


#15

Hank, forgot to add, that in regards to the “UPDATE THE” statement table we will
try to look up is actually “THE” and it isn’t valid syntax either at least
according to MS documentation.

Update the Administration.dbo.DirectEnergy_DirectDebitInfo_TBC

set

regards,

Alexander
image004.jpeg


#16

Hank, forgot to add, that in regards to the “UPDATE THE” statement table we will
try to look up is actually “THE” and it isn’t valid syntax either at least
according to MS documentation.

Update the Administration.dbo.DirectEnergy_DirectDebitInfo_TBC

set

regards,

Alexander
image001.gif


#17

Hank, forgot to add, that in regards to the “UPDATE THE” statement table we will
try to look up is actually “THE” and it isn’t valid syntax either at least
according to MS documentation.

Update the Administration.dbo.DirectEnergy_DirectDebitInfo_TBC

set

regards,

Alexander
image003.jpeg


#18

Hank, forgot to add, that in regards to the “UPDATE THE” statement table we will
try to look up is actually “THE” and it isn’t valid syntax either at least
according to MS documentation.

Update the Administration.dbo.DirectEnergy_DirectDebitInfo_TBC

set

regards,

Alexander
image005.jpeg


#19

Hank, forgot to add, that in regards to the “UPDATE THE” statement table we will
try to look up is actually “THE” and it isn’t valid syntax either at least
according to MS documentation.

Update the Administration.dbo.DirectEnergy_DirectDebitInfo_TBC

set

regards,

Alexander
image002.jpeg


#20

Hank, forgot to add, that in regards to the “UPDATE THE” statement table we will
try to look up is actually “THE” and it isn’t valid syntax either at least
according to MS documentation.

Update the Administration.dbo.DirectEnergy_DirectDebitInfo_TBC

set

regards,

Alexander
image006.jpeg