Tigger problem isql (Interbase7)

Thread View: borland.public.interbase.sql

4 messages

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

4 total messages Started by Franca Lord Tue, 17 Dec 2002 18:38

#11054

Author: 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: ........."

Re: Tigger problem isql (Interbase7)

#11055

Author: Jeff Overcash (TeamB)
Date: Tue, 17 Dec 2002 19:09

30 lines
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)

Re: Tigger problem isql (Interbase7)

#11056

Author: Franca Lord
Date: Tue, 17 Dec 2002 20:31

36 lines
2322 bytes

Thanks Jeff, I think I am using the latest IBConsole, as I had it shipped to
me only last week. I have excluded the SET TERM and it has now worked.
"Jeff Overcash (TeamB)" <jeffovercash@mindspring.com> wrote in message
news:3DFF7658.F465C696@mindspring.com...
> 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)

Re: Tigger problem isql (Interbase7)

#11059

Author: Jeff Overcash (TeamB)
Date: Wed, 18 Dec 2002 04:33

24 lines
1959 bytes

Franca Lord wrote:
> 
> Thanks Jeff, I think I am using the latest IBConsole, as I had it shipped to
> me only last week.

No you are not using the latest.  I have put two updates on CodeCentral to
IBConsole since RTM.  Most of the changes were fixes to the new scripting that
does not require SET TERM.

>  I have excluded the SET TERM and it has now worked.

Go to http://codecentral.borland.com/codecentral/ccweb.exe/author?authorid=102
to get the latest copy.

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

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