Toad World® Forums

NEW capitalized or not capitalized


#1

Hi

If you enter new it gets capitalized …but if you use formatter it will get “lowered”.

(found out this when editing a trigger and using :new)

Regards

PS: It’s not a question. sorry.

Message was edited by: Fsilva


#2

Hi Filipe,

In fact the :new is an identifier rather than a keyword. “New” can be either keyword and identifier in the trigger. In the clause below, the first “NEW” is keyword while the second is identifier:
REFERENCING NEW AS new OLD AS old

Formatter can detect whether the “new” is a keyword or an identifier and decide to capitalize or not capitalize it correctly. But the preference “Keywords to Uppercase” doesn’t have such intelligence. I will raise an enhancement request to improve this in the future.

Thanks,
Vincent