I have the same problems with 4.7Beta14. If you write

set term !! ;
create procedure xxx
as
begin
...;
end!!
set term ; !!

you'll get the exception. The same thing worked under 4.6Bc or if you
change it to

set term ~ ;
create procedure xxx
as
begin
...;
end~
set term ; ~

@Jason: Will it be possible to use "!!" as terminator in IBO 4.7Final
or do I have to change my SQL-Scripts?

--- In IBObjects@yahoogroups.com, "dcanyas2" <dcanyas@...> wrote:
>
> If I have a sentence SQL that a SET TERM uses who has but of a
> character this sentence he gives an error of execution 335544569,
thus
> this sentence fails when it is executed:
>
> SET TERM !!;
>
> ALTER TRIGGER BIU_PRECIOSESPCLIENTES
> ACTIVE BEFORE INSERT OR UPDATE
> AS
> BEGIN
> if (NEW.Precio1=0) then NEW.Precio1=null;
> END!!
>
> SET TERM; !!
>
> But this executes:
>
> SET TERM !;
>
> ALTER TRIGGER BIU_PRECIOSESPCLIENTES
> ACTIVE BEFORE INSERT OR UPDATE
> AS
> BEGIN
> if (NEW.Precio1=0) then NEW.Precio1=null;
> END!
>
> SET TERM; !
>
>
> This error not occur with version 4.6 of the IBO
>