I agreeto Idea Code completion in UPDATE..SET..FROM

6 votes

Rank3

Idea#34

This idea is active.
SQL Editor »

Code completion in UPDATE..SET..FROM

Toad should support code completion in UPDATE..SET..FROM

For example, code completion for:

UPDATE x

SET foo=123

FROM Bar x

should work the same as for:

UPDATE Bar

SET foo=123

Toad should support code completion for joins in FROM statement:

UPDATE x

SET foo=123

FROM Bar x JOIN Bar2 y ON x.id=y.xid

WHERE y.foo2 = 234

Tags:

Comment

Submitted by kdebski85 1 year ago

Similar Ideas Show

Events

  1. The idea was posted
    1 year ago

Comments (3)

  1. Moderator Comment
    olga.kirillova

    Thanks for the idea!

    1 year ago
    1 Vote upto Comment
  2. Community Member

    Yes, please get this done! I shouldn't have to rem out "UPDATE Mytable" just to be able to get the code completion on Joins, fields, etc.

    1 year ago
    1 Vote upto Comment
  3. kdebski85

    Is there any schedule for this feature?

    Will it be done for 6.0?

    1 month ago
    0 Vote upto Comment