Re: trigger error

Article View: borland.public.interbase.sql

Article #11240

Back to borland.public.interbase.sql Previous Next

#11240

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

Technical Details

Message-ID: <kqecuucmik71na1r6orbi79biitfr33gb9@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3de5dbae@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,b59826838ffc35f
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-11-28 08:09:03 PST
From: Bill Todd <bill@notthis.dbginc.com>
Newsgroups: borland.public.interbase.sql
Subject: Re: trigger error
Date: Thu, 28 Nov 2002 08:51:14 -0700
Message-ID: <kqecuucmik71na1r6orbi79biitfr33gb9@4ax.com>
References: <3de5dbae@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.207.211.30
X-Trace: newsgroups.borland.com 1038498676 216.207.211.30 (28 Nov 2002 07:51:16 -0800)
Lines: 33
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message