table name prepended to column names in INSERT column list

bstrautin

If the "Qualify column names with table name" option is set, SQL Prompt incorrectly qualifies column names in an INSERT statement's column list.

For example, for table 'Foo' with column 'FooID', if I type

INSERT INTO foo (f[tab]

I get:

INSERT INTO Foo (Foo.FooID

This is invalid SQL. Instead, the code should looke like:

INSERT INTO Foo (FooID

Anu D

Many thanks for your post.

When you use the 'Auto-Insert' option SQL Prompt provides this same query works fine.

For that make sure you have following option selected: SQL prompt 5 --> options --> Inserted Code --> Objects & Statements --> Insert Full Insert statement.

And after saving the setting above in a new query window type :

INSERT INTO foo[tab]

and it will insert code and not qualify it with column names.

Please let me know how you get on with it.