Toad World® Forums

TOAD SS 6.5.0.23 BETA BUG - UPDATE..SET...FROM..WHERE... - wrong columns after SET

Let say I have code:

UPDATE b
SET
FROM A a
JOIN B b ON a.bid=b.id
WHERE a.id=222

Now I place the cursor after “SET” and invoke code completion (ctrl + .).

Column list is displayed from table A, which is wrong. I am updating table B, not A.

If I change an order of tables after FROM everything is ok - columns from table B are shown.

It seems that the first table after FROM is always considered, not an aliased one.

Hi Chris

I ’ ve check this issue, yes, the code completion should the the column b,

I have create TSS-606 for it ,we will try to fix it in next beta.

Thanks,

Cathy.

Hi Chris,

This issue have been resolved in TSS 6.7 Beta , you can verified it on the latest beta version.

Thanks,

Cathy.