Subject | RE: [firebird-support] query optimization- MAX() from .. WHERE |
---|---|
Author | Svein Erling Tysvær |
Post date | 2010-08-18T11:06:49Z |
I wrote:
new.NUMER_NEG = -new.NUMER
of course
Set
>SET TERM ^^ ;Sorry, I meant
>CREATE TRIGGER TRG_NUMER_NEG FOR TEST_TAB ACTIVE BEFORE INSERT POSITION 0 AS
>begin
> new.NUMER_NEG = new.-NUMER
>end^^
>SET TERM ; ^^
new.NUMER_NEG = -new.NUMER
of course
Set