Toad World® Forums

Schema name missing on FOLLOWS clause of trigger

Howdy!

When altering (and presumably creating) a trigger in another schema using the SB to have a FOLLOWS clause, Toad correctly shows the existing triggers to be selected to follow, but does not put the schema name in the SQL.

So, this trigger fragment:

CREATE OR REPLACE TRIGGER OTHERSCHEMA.BLEAH_IU
BEFORE INSERT OR UPDATE
ON OTHERSCHEMA.BLEAH
FOR EACH ROW
FOLLOWS BLEAH_ID
BEGIN

...should be:

CREATE OR REPLACE TRIGGER OTHERSCHEMA.BLEAH_IU
BEFORE INSERT OR UPDATE
ON OTHERSCHEMA.BLEAH
FOR EACH ROW
FOLLOWS OTHERSCHEMA.BLEAH_ID
BEGIN

Thanks!
Rich

p.s. In Toad 13.2.0.151, but I didna check older versions.

Thanks Rich. Pretty sure that one's been in Toad for a while now. Fixed for next beta.

1 Like