Beware the Autocomplete in the trigger editor
Posted: Tue 12 May 2009 05:43
When creating a trigger procedure, it is handy to have the autocomplete function - usually.
But there is a time it is not.
Try typing in a statement likeIt gets conveniently changed to as soon as you press the .
and then you blithely type in the the rest of your column name.
So what is the meaning of:??? 
A confused KiwiJem
But there is a time it is not.
Try typing in a statement like
Code: Select all
SET OLD.Code: Select all
SET OLD_PASSWORDS.and then you blithely type in the the rest of your column name.
So what is the meaning of:
Code: Select all
SET_OLDPASSWORDS.CustomerIDA confused KiwiJem