Guillermo,

Instead of "SET TERM ;^ " use
SET TERM ^;

Luiz.

----- Original Message -----
From: "Guillermo Najar-Arreola" <gnajar@...>
Newsgroups: egroups.ib-support
To: <ib-support@yahoogroups.com>
Sent: Tuesday, September 17, 2002 5:56 PM
Subject: [ib-support] Token unknown TERM


> 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?
>