Thank you Luiz !

""Luiz"" <cprmlao@...> wrote in message
news:010801c25e8f$e3ed01d0$0a0aa8c0@......

> 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?
> >
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>