Erro ao criar TRIGGER

Firebird

27/08/2003

Olá pessoal,

estou tentando criar uma trigger e o seguinte erro acontece:

Dynamic SQL Error
SQL error code = -104
Unexpected end of command
Statement: CREATE TRIGGER tI_prc_parcela FOR prc_parcela AFTER INSERT AS
/* ERwin Builtin Wed Aug 27 20:12:02 2003 */
/* INSERT trigger on prc_parcela */
DECLARE VARIABLE numrows INTEGER


o código para criação das TRIGGER é:

CREATE TRIGGER tD_prc_parcela FOR prc_parcela AFTER DELETE AS
/* ERwin Builtin Wed Aug 27 20:12:02 2003 */
/* DELETE trigger on prc_parcela */
DECLARE VARIABLE numrows INTEGER;
BEGIN
/* ERwin Builtin Wed Aug 27 20:12:02 2003 */
/* vnd_venda R/7 prc_parcela ON CHILD DELETE CASCADE */
delete from vnd_venda
where
/* OLD.vnd_id = vnd_venda.vnd_id and
OLD.vnd_tipo = vnd_venda.vnd_tipo */
OLD.vnd_id = vnd_venda.vnd_id and
OLD.vnd_tipo = vnd_venda.vnd_tipo;


/* ERwin Builtin Wed Aug 27 20:12:02 2003 */
END !!

CREATE TRIGGER tI_prc_parcela FOR prc_parcela AFTER INSERT AS
/* ERwin Builtin Wed Aug 27 20:12:02 2003 */
/* INSERT trigger on prc_parcela */
DECLARE VARIABLE numrows INTEGER;
BEGIN
/* ERwin Builtin Wed Aug 27 20:12:02 2003 */
/* vnd_venda R/7 prc_parcela ON CHILD INSERT RESTRICT */
select count(*)
from vnd_venda
where
/* NEW.vnd_id = vnd_venda.vnd_id and
NEW.vnd_tipo = vnd_venda.vnd_tipo */
NEW.vnd_id = vnd_venda.vnd_id and
NEW.vnd_tipo = vnd_venda.vnd_tipo into numrows;
IF (
/* */

numrows = 0
) THEN
BEGIN
EXCEPTION ERWIN_CHILD_INSERT_RESTRICT;
END


/* ERwin Builtin Wed Aug 27 20:12:02 2003 */
END !!

CREATE TRIGGER tU_prc_parcela FOR prc_parcela AFTER UPDATE AS
/* ERwin Builtin Wed Aug 27 20:12:02 2003 */
/* UPDATE trigger on prc_parcela */
DECLARE VARIABLE numrows INTEGER;
BEGIN
/* ERwin Builtin Wed Aug 27 20:12:02 2003 */
/* vnd_venda R/7 prc_parcela ON CHILD UPDATE CASCADE */
insert into vnd_venda (vnd_id,
vnd_tipo)
select vnd_id,
vnd_tipo
from prc_parcela
where
/* */

not exists (
select * from vnd_venda
where
/* NEW.vnd_id = vnd_venda.vnd_id and
NEW.vnd_tipo = vnd_venda.vnd_tipo */
NEW.vnd_id = vnd_venda.vnd_id and
NEW.vnd_tipo = vnd_venda.vnd_tipo
);


/* ERwin Builtin Wed Aug 27 20:12:02 2003 */
END !!

Agradeço a kem puder ajudar!


Nando

Nando

Curtidas 0

Respostas

Afarias

Afarias

27/08/2003

Onde vc está rodando este script?! Vc tem que definir o ´terminador´ ::

SET TERM !!;


T+


GOSTEI 0
POSTAR