Drop Down in Calculated Fields does not drop down and pasting does not paste multiple lines. (4225623)

Open the calculated field window in Query builder. Create/select a name for the calculated. Below, click Field Definition drop down to open up as a window. In that window is another drop down at the top. This does not drop down as a window. If attempting to paste a multiple line statement into this field, only the first line is pasted in.

Example:

CASE
          WHEN FROM_TO_ERROR = '1' THEN 'It is 1'
          WHEN FROM_TO_ERROR = '2' THEN 'It is 2'
          ELSE 'It is something else'
       END

But in the calc field, it only pastes:
CASE

The rest of the statment does not paste.

WORKAROUND:

Do not try to paste multiple lines. Remove any end of line characters and then paste in the field. Or manually type out the statment or use the function and field options availabled.

Sample:

Use this...

CASE WHEN FROM_TO_ERROR = '1' THEN 'It is 1' WHEN FROM_TO_ERROR = '2' THEN 'It is 2' ELSE 'It is something else' END

Instead of this...

CASE
          WHEN FROM_TO_ERROR = '1' THEN 'It is 1'
          WHEN FROM_TO_ERROR = '2' THEN 'It is 2'
          ELSE 'It is something else'
       END

STATUS:

Waiting for fix in a furture version of Toad Data Point