trigger error

Thread View: borland.public.interbase.sql

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Alessandro Martim Thu, 28 Nov 2002 09:05

#11237

Author: Alessandro Martim
Date: Thu, 28 Nov 2002 09:05

22 lines
1373 bytes

hi all

I've trying to create the trigger below w/o success... I am using ib6 and
ibconsole.

thanks in advance

error: Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, char 25
AS

----------------
SET TERM !!;
CREATE TRIGGER TR_TROCA_DEPTO FOR CARGO BEFORE UPDATE
AS
  DECLARE VARIABLE N_CARG AS INTEGER;
BEGIN
  IF (OLD.DEPTO <> NEW.DEPTO) THEN

    ***
END

Re: trigger error

#11238

Author: Rafael Vacas
Date: Thu, 28 Nov 2002 09:28

26 lines
1394 bytes

> I've trying to create the trigger below w/o success... I am using ib6 and
> ibconsole.
>
> thanks in advance
>
> error: Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 3, char 25
> AS
>
> ----------------
> SET TERM !!;
> CREATE TRIGGER TR_TROCA_DEPTO FOR CARGO
ACTIVE BEFORE UPDATE
> AS
>   DECLARE VARIABLE N_CARG AS INTEGER;
> BEGIN
>   IF (OLD.DEPTO <> NEW.DEPTO) THEN
>
>     ***
END !!
>
>

Rafael
A Coru�a

Re: trigger error

#11239

Author: Hilmar Brodner
Date: Thu, 28 Nov 2002 15:35

3 lines
1109 bytes

> >   DECLARE VARIABLE N_CARG AS INTEGER;

DECLARE VARIABLE N_CARG INTEGER;

Re: trigger error

#11240

Author: Bill Todd
Date: Thu, 28 Nov 2002 15:51

33 lines
1629 bytes

Remove the word AS from the DECLARE VARIABLE statement.

On Thu, 28 Nov 2002 07:05:36 -0200, "Alessandro Martim"
<alessandro.marti@uol.com.br> wrote:

>hi all
>
>I've trying to create the trigger below w/o success... I am using ib6 and
>ibconsole.
>
>thanks in advance
>
>error: Dynamic SQL Error
>SQL error code = -104
>Token unknown - line 3, char 25
>AS
>
>----------------
>SET TERM !!;
>CREATE TRIGGER TR_TROCA_DEPTO FOR CARGO BEFORE UPDATE
>AS
>  DECLARE VARIABLE N_CARG AS INTEGER;
>BEGIN
>  IF (OLD.DEPTO <> NEW.DEPTO) THEN
>
>    ***
>END
>


--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads