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.
Per visualizzare gli articoli della Knowledge Base di livello avanzato, è necessario aver effettuato l'accesso e disporre di un contratto di manutenzione in essere.
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center