Subject | RE: [IBO] Error with a Set term of several characters |
---|---|
Author | Jason Wharton |
Post date | 2007-01-20T23:55:19Z |
> If I have a sentence SQL that a SET TERM uses who has but of aI tested this in the soon to be released Beta 15 of IBO 4.7 and it does
> 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; !
appear to work as it should.
Either I need more specific circumstances or I inadvertently fixed it
somehow.
Jason Wharton