Subject | Error with a Seth term of several characters |
---|---|
Author | dcanyas2 |
Post date | 2007-01-15T10:47:05Z |
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
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