Formatter options are not being applied to the Generate Statements tool when copied to clipboard (4231549)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Formatter options are not being applied to the Generate Statements tool when copied to clipboard
Description

After using the "Generate SQL Statement" tool on a table and when it's copied to clipboard, pasting the statement puts 3 columns per line:
SELECT
"Adjust", "SLevel", "Access",
"MaxAmount", "LimitedTo"
FROM MyTable;
It's possible to setup in the Formatter options so that all columns are on one line just fine after the fact:
SELECT
"Adjust",
"SLevel",
"Access",
"MaxAmount",
"LimitedTo"
FROM MyTable;
However, when generating another Select statement using the Generate Select Statement tool, it's again copied to clipboard and when pasted it's not formatted per the formatter options.
Resolution

WORKAROUND:
After pasting the SQL to the Editor, click on the format button manually.
If planning on saving the generated SQL to a file, go to View | Toad Options | Editor - Open/Save. Then locate the check box "Format files when opened" and check it. Click Apply and OK. The next time the file is opened, it will be formated automatically for all subsequet uses of the generate statement tool.
STATUS:
An Enhancement Request has been created to include a feature to auto format when generating the statement.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title