RE: Multiple "When" in Trigger
procedure spl_good(var1 tipo) returning any
begin
if var1 = 1 then
code spl_1
elseif var1=2
code spl_2
endif
end
create trigger example1insert on tab_1 referencing new as not_old
for each row (execute spl_1());
regards
MCA
Aunque hay mas de una forma de pelar un gato, finalmente elejimos una.
(ALF)
----------
} De: JoSchneidr <joschneidr@aol.com>
} A: informix-list@rmy.emory.edu
} Asunto: Multiple "When" in Trigger
} Fecha: Thursday 16 de October de 1997 13:25
}
} Hy out there,
} my question may sound strange but is there a possibility to have more
} then one WHEN-Condition in a trigger ?
}
} I tried out something like this :
}
} create trigger example1
} insert on tab_1 referencing new as not_old
} for each row when (a=1) (execute spl_1());
} when (a=2) (execute spl_2());
}
} I tried out multiple version with changing syntax but there is always a
syntax
} error
} after the first "when" condition.
}
} Any help would be appreciated.
}