Subject | [newbie] Delete related Records? |
---|---|
Author | Joaquim Macedo <joaquimmacedo@yahoo.com> |
Post date | 2003-01-23T16:32:40Z |
Hi all.
Suppose that I have 2 tables. These are related with a Foreign Key on
field: FIELD_RELATED.
If I delete a record on a TABLE_1, I would like that a record(s)
would be deleted also on TABLE_2, where: TABLE_1.FIELD_RELATED =
TABLE_2.FIELD_RELATED .
What is the best approach to do this?
1) Use database triggers,
2) Use the TIB_Query.DeleteSQL property,
3) Define it on the Foreign Key,
4) Another ...?
Thanks a lot in advance.
Best regards,
Joaquim.
Suppose that I have 2 tables. These are related with a Foreign Key on
field: FIELD_RELATED.
If I delete a record on a TABLE_1, I would like that a record(s)
would be deleted also on TABLE_2, where: TABLE_1.FIELD_RELATED =
TABLE_2.FIELD_RELATED .
What is the best approach to do this?
1) Use database triggers,
2) Use the TIB_Query.DeleteSQL property,
3) Define it on the Foreign Key,
4) Another ...?
Thanks a lot in advance.
Best regards,
Joaquim.