trigger error

Article View: borland.public.interbase.sql

Article #11237

Back to borland.public.interbase.sql Previous Next

#11237

From: 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

Technical Details

Message-ID: <3de5dbae@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,b59826838ffc35f,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-11-28 01:09:16 PST
Reply-To: "Alessandro Martim" <alessandro.marti@uol.com.br>
From: "Alessandro Martim" <alessandro.marti@uol.com.br>
Newsgroups: borland.public.interbase.sql
Subject: trigger error
Date: Thu, 28 Nov 2002 07:05:36 -0200
Lines: 24
Organization: .
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 200.226.119.83
Message-ID: <3de5dbae@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1038474158 200.226.119.83 (28 Nov 2002 01:02:38 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail