Erro na Trigger.
.Estou criando esta trigger e está me dando o erro de: O que devo fazer?
Erro:
SQL Error code = -104
Unexpected end of command
SQL:
/* Trigger TarFaiCon - BEFORE UPDATE */
CREATE TRIGGER TarFaiCon_BU FOR TarFaiCon
BEFORE UPDATE AS
DECLARE VARIABLE vConsumo INTEGER;
BEGIN
NEW.ConIni = 0;
EXECUTE PROCEDURE FAICONINI( NEW.TipCat, NEW.Ano, NEW.Mes, NEW.ConFin ) RETURNING_VALUES :vConsumo;
NEW.ConIni = vConsumo;
END @
Erro:
SQL Error code = -104
Unexpected end of command
SQL:
/* Trigger TarFaiCon - BEFORE UPDATE */
CREATE TRIGGER TarFaiCon_BU FOR TarFaiCon
BEFORE UPDATE AS
DECLARE VARIABLE vConsumo INTEGER;
BEGIN
NEW.ConIni = 0;
EXECUTE PROCEDURE FAICONINI( NEW.TipCat, NEW.Ano, NEW.Mes, NEW.ConFin ) RETURNING_VALUES :vConsumo;
NEW.ConIni = vConsumo;
END @
Havilux
Curtidas 0
Respostas
Cabreu.jr
12/01/2004
tente usar ´set term ^;´ (sem aspas) antes do create trigger
e termine com ´^´ apos o END
e termine com ´^´ apos o END
GOSTEI 0