Poor experience with intellisense

Toad for SQL Server
1

I wish Toad may improve its SQL Intellisense. With this simple query it does not work at all:

UPDATE rf SET
rf.REFILL_DONE = 1
FROM RK_CP_TERM_REFILLS rf
inner join RK_NEW_REQUESTS r on r.ID = rf.REFILL_REQUEST_ID
WHERE r.STATUS = dbo.cRkReqStatSucc()
and IsNull(rf.REFILL_DONE,0)=0

This query runs OK, so it is correct, but Toad is unable to sense columns from both tables.

Also Toad does not provide help on SQL Functions.

Tested in both 5.5 3001 and Beta6.6 build 604.

Meanwhile it works fine when using competing products:

5460.scr1.png

7723.scr2.png
7723.scr2.png762×402 35.2 KB

2

Hi Anton,

I totally agree with you.

Best regards,

Sergio

3

Hi Anton and Sergio,

Thank you very much for your sugestion. We already have story TSS-909 for this and we will discuss about this. We will keep you update.

Best Regards,

Kelly

4

Hi Kelly,

I appreciate too much your position.

Now, its’ time to make better some parts of TOAD, for example SQL Editor and intellisense.

If you try competitors and see what’s they do, they have some features, like for example code or help suggestion that are most useful when you write sql statements.

Only with last beta of TOAD you introduce auto-alias in statement sql.

Now we are in 2015.

Competitors make available this features from many years.

I stay tune for your update in the future.

Best regards,

Sergio