Subject Re: [firebird-support] Set term gives Token unknown error
Author Aage Johansen
Stevio wrote:
>> From: "Aage Johansen" <aagjohan@...>
>> 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?
>
> ------------------------------------

Nevertheless, I just ran this:
-----------------------------
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.