dcanyas2 schrieb:

> 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; !!

It should always look like:
SET TERM ;!!
and not like:
SET TERM; !!

Add a blank AFTER the TERM, then the new terminator then the old one and
vice versa.

> But this executes:
> SET TERM; !

I thought it shouldn't.
Does it execute when used on its own or only within the two statements
you posted?


Luc.