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()
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: