Subject | Re: [firebird-support] Set term gives Token unknown error |
---|---|
Author | Aage Johansen |
Post date | 2008-04-25T20:55:44Z |
Stevio wrote:
-----------------------------
set term ^;
create trigger TRG_TAPELBL for TAPELBL
active
before insert
as
begin
new.ID = gen_id(X,1);
end^
set term ;^
commit;
-----------------------------
Firebird/1.5.4
IB_SQL (IBO(4.8.5)
Will not work in the DSQL pane, of course.
Try to show your actual code, and tell us how/where/what you are doing.
--
Aage J.
>> From: "Aage Johansen" <aagjohan@...>Nevertheless, I just ran this:
>> Using set term ^; in the script pane of IB_SQL should work fine.
>
> It doesn't however. Here is the actual error I get:
>
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 1, char 5
> term
>
> STATEMENT:
> TIB_DSQL: "<TApplication>.frmSQL.dsqlEdit."
>
>
> Any ideas anyone? What am I doing wrong?
>
> ------------------------------------
-----------------------------
set term ^;
create trigger TRG_TAPELBL for TAPELBL
active
before insert
as
begin
new.ID = gen_id(X,1);
end^
set term ;^
commit;
-----------------------------
Firebird/1.5.4
IB_SQL (IBO(4.8.5)
Will not work in the DSQL pane, of course.
Try to show your actual code, and tell us how/where/what you are doing.
--
Aage J.