Tigger problem isql (Interbase7)

Article View: borland.public.interbase.sql

Article #11054

Back to borland.public.interbase.sql Previous Next

#11054

From: Franca Lord
Date: Tue, 17 Dec 2002 18:38

15 lines
1290 bytes

Can anyone please help!
try to run the this:

 SET TERM !! ;
 CREATE TRIGGER set_emp_no FOR Employee
 BEFORE INSERT AS
 BEGIN
     new.emp_no = gen_id(emp_no_gen, 1);
 END !!
 SET TERM ; !!

"And came up with this error:
Dynamic SQL Error
Token unknown -line 5, Char 4
:on line 2: ........."

Technical Details

Message-ID: <3dff6f59$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!opentransit.net!fr.clara.net!heighliner.fr.clara.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,26889ba2312d908,start
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-17 10:41:23 PST
From: "Franca Lord" <franca@blueyonder.co.uk>
Newsgroups: borland.public.interbase.sql
Subject: Tigger problem isql (Interbase7)
Date: Tue, 17 Dec 2002 18:38:47 -0000
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 62.30.115.98
Message-ID: <3dff6f59$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040150361 62.30.115.98 (17 Dec 2002 10:39:21 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!opentransit.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail