Subject | Token unknown TERM |
---|---|
Author | Guillermo Najar-Arreola |
Post date | 2002-09-17T20:56:07Z |
Hi,
I have the following code:
SET TERM ; ^
CREATE TRIGGER tU_CLIENTE FOR CLIENTE AFTER UPDATE AS
DECLARE VARIABLE numrows INTEGER;
BEGIN
IF
(OLD.OID_CLIENTE <> NEW.OID_CLIENTE) THEN
BEGIN
update REGOPER_ENC
set
REGOPER_ENC.OID_CLIENTE = NEW.OID_CLIENTE
where
REGOPER_ENC.OID_CLIENTE = OLD.OID_CLIENTE;
END
END ^
and I get "Invalid Token TERM"; I'm using Firbird 1.0, dialect 3. Is ther a
change on the SET TERM syntax on Firebird?
Thanx
Guillermo
I have the following code:
SET TERM ; ^
CREATE TRIGGER tU_CLIENTE FOR CLIENTE AFTER UPDATE AS
DECLARE VARIABLE numrows INTEGER;
BEGIN
IF
(OLD.OID_CLIENTE <> NEW.OID_CLIENTE) THEN
BEGIN
update REGOPER_ENC
set
REGOPER_ENC.OID_CLIENTE = NEW.OID_CLIENTE
where
REGOPER_ENC.OID_CLIENTE = OLD.OID_CLIENTE;
END
END ^
and I get "Invalid Token TERM"; I'm using Firbird 1.0, dialect 3. Is ther a
change on the SET TERM syntax on Firebird?
Thanx
Guillermo