Article View: borland.public.interbase.sql
Article #11055Re: Tigger problem isql (Interbase7)
From: Jeff Overcash (TeamB)
Date: Tue, 17 Dec 2002 19:09
Date: Tue, 17 Dec 2002 19:09
30 lines
2057 bytes
2057 bytes
Works for me. Make certain you have the latest IBConsole (if that is what you
are using) from CodeCentral. The shipping version had problems with the old
style SET TERM as it no longer needs SET TERM.
Franca Lord wrote:
>
> 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: ........."
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Maybe it was infatuation or the thrill of the chase.
Maybe you were always beyond my reach and my heart was playing safe.
But was that love in your eye I saw or the reflection of mine?
Give me time, won't you give me that time!
Welcome back to the circus. (Fish)
Technical Details
Message-ID:
<3DFF7658.F465C696@mindspring.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!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!proxad.net!proxad.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3dff6f59$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 114a0e,26889ba2312d908 X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-12-17 11:10:01 PST Message-ID: <3DFF7658.F465C696@mindspring.com> Date: Tue, 17 Dec 2002 14:09:12 -0500 From: "Jeff Overcash (TeamB)" <jeffovercash@mindspring.com> Organization: TeamB X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: borland.public.interbase.sql Subject: Re: Tigger problem isql (Interbase7) References: <3dff6f59$1@newsgroups.borland.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 66.32.66.27 X-Trace: newsgroups.borland.com 1040151979 66.32.66.27 (17 Dec 2002 11:06:19 -0800) Lines: 30 X-Authenticated-User: overcash 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!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!proxad.net!proxad.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail