Home > database >  About a simple Spaces at the end of the trigger to field and press enter
About a simple Spaces at the end of the trigger to field and press enter

Time:09-26

Today has built a table, but this simple trigger is always a problem, ask you intend to show

Is want to taxno Spaces at the end of the

But this trigger has been out of the question; As shown in figure: update taxno field has an error

CodePudding user response:

The BEGIN
: new infoid:=RTRIM (: new. Infoid);
END;

The begin and the and the middle is that a what all don't you can't read the data row level triggers will produce variation table problem you don't need at present

CodePudding user response:

: new infoid:=RTRIM (: new. Infoid);

CodePudding user response:

Trigger can't to SQL operations of its own table, the correct way is: : new. Infoid:=RTRIM (: new. Infoid);
  • Related