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
