Toad World® Forums

Code Assist doesn't work with top or distinct.

If I write the following query:

select * from tableA

And wish to get a list of fields, I simply need to delete the * and press the spacebar for a list of fields. However, if I have the following:

select distinct from tableA

No code assist will come up. The same thing happens with

select top 1000 from tableA

Are you aware of this bug?

Hi David,
thanks for the hint. For now there is no such support even in TSS 5.6 beta (which was improved in this particular area as well as others). we have CR90838 to track this request.

Hi David,
thanks for the hint. For now there is no such support even in TSS 5.6 beta (which was improved in this particular area as well as others). we have CR90838 to track this request.

Unsubscribe

Sent on the Sprint® Now Network from my BlackBerry®

Good Catch David !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image001.gif

Good Catch David !!!

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

Hank.Freeman50 (Skype)
image002.jpeg