Subject | How I can know the value of a parent table? |
---|---|
Author | W O |
Post date | 2011-03-26T04:04:17Z |
Hello everybody
I am using Firebird 2.1
I have a parent table (MOVIMCAB) and a child table (MOVIMDET)
In a trigger of MOVIMDET I want to access a value of MOVIMCAB, something
like that:
IF (MOVIMCAB.MVC_TIPMOV = 'E') THEN
UPDATE ....
but the message "column unknown" appears. Why? How I can know the value of
the related column of MOVIMCAB?
MOVIMDET has a foreign constraint:
ALTER TABLE MOVIMDET ADD CONSTRAINT FK_MOVIMDET1 FOREIGN KEY (MOV_IDENTI)
REFERENCES MOVIMCAB(MVC_IDENTI);
Thanks in advance.
[Non-text portions of this message have been removed]
I am using Firebird 2.1
I have a parent table (MOVIMCAB) and a child table (MOVIMDET)
In a trigger of MOVIMDET I want to access a value of MOVIMCAB, something
like that:
IF (MOVIMCAB.MVC_TIPMOV = 'E') THEN
UPDATE ....
but the message "column unknown" appears. Why? How I can know the value of
the related column of MOVIMCAB?
MOVIMDET has a foreign constraint:
ALTER TABLE MOVIMDET ADD CONSTRAINT FK_MOVIMDET1 FOREIGN KEY (MOV_IDENTI)
REFERENCES MOVIMCAB(MVC_IDENTI);
Thanks in advance.
[Non-text portions of this message have been removed]