Subject Re: [firebird-support] How I can know the value of a parent table?
Author W O
Post date 2011-03-26T18:22:04Z
Excellent.

Thank you very much.




Define a variable in your trigger, then do something like
>
> SELECT MVC_TIPMOV FROM MOVIMCAB MC where MC.MVC_IDENTI = new.MOV_IDENTI
> into :MyVariable;
> IF (MyVariable = 'E') THEN
> UPDATE ...
>
> HTH,
> Set
>
>


[Non-text portions of this message have been removed]