The following error occurs when doing Alter Trigger from the Operations menu in the Object Explorer:
System.NullReferenceException: Object reference not set to an instance of an object.
Stack trace:
at Quest.Toad.Sybase.Doe.ASE.Trigger.TriggerEditForm.Initialize()
at Quest.Toad.Doe.BaseDoeForm.BaseDoeForm_Load(Object sender, EventArgs e)
at Quest.Toad.Doe.BaseDoeForm.PreShowInitialize()
at Quest.Toad.Doe.BaseDoeForm.Alter(Object sender, UIActionEntry uiEntry, ITrl[] trls, Object customModeTag)
at Quest.Toad.Doe.BaseDoeForm.Alter(Object sender, ItemClickEventArgs e, Object customModeTag)
at Quest.Toad.Doe.BaseDoeForm.Alter(Object sender, ItemClickEventArgs e)
parser issue when code includes uppercase in the following:
'for Update' or 'for Insert' etc.
WORKAROUND
Load the trigger into the editor and recreate trigger with 'for update' instead of 'for Update'. Once that is done, the trigger can be altered via the Object Explorer.
STATUS
Waiting for a fix in a future release of Toad for Sybase.