Subject RE: [IBO] Error with a Set term of several characters
Author Jason Wharton
> 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; !

I tested this in the soon to be released Beta 15 of IBO 4.7 and it does
appear to work as it should.

Either I need more specific circumstances or I inadvertently fixed it
somehow.

Jason Wharton