INSERT INTO .... shows VALUES()

TSchwabTSchwab Posts: 80
In 3.9 SQL-Prompt did not insert the VALUES () if I had a SELECT .... following the INSERT INTO...

Any chance to get this behaviour in 4.0 (or would it be possible to get the INSERT INTO ...columns without VALUES())???

Thanks,

Regards,
Thorsten
Regards,

Thorsten

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post Thorsten.

    Can you kindly let us what settings allowed you to get the output:
    INSERT INTO ...columns without VALUES() in 3.9?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Hello Anu,

    I think I had it at the same setting than in 4.0.

    You can reproduce the behaviour if you try this:

    First type the SELECT statement... like...


    SELECT ColumnName
    FROM table1

    then, place the cursor on the row above the SELECT statement and type ii (TAB) to get INSERT INTO and then choose any table and press TAB again and you will only get the INSERT INTO TableName (Column1, Colum2, etc...)

    with out the VALUES(....)

    That was a great feature and that one is missing... I don't need the VALUES....
    :cry:

    Any chance to get it "repaired" very soon?

    Thanks.
    Regards,

    Thorsten
    Regards,

    Thorsten
  • Anything new to this case?
    Regards,

    Thorsten
  • Will this "feature" be implemented in a future release?
    Regards,

    Thorsten
Sign In or Register to comment.