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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
