Subject | Checking Referential Integrity in code |
---|---|
Author | Frank Wang |
Post date | 2001-12-17T23:41:22Z |
Hi All,
I have a table customer which is being referenced by many other
tables, I'd like to know if there is
a generic way to check in Delphi code or SP if a certain record in the
customer table has been referenced
by any of those tables? example, a sql can be built based on the
relationship defined in the .gdb and used
to query into affected tables to see if referencing record exists, thanks
for any help.
Regards,
Frank
I have a table customer which is being referenced by many other
tables, I'd like to know if there is
a generic way to check in Delphi code or SP if a certain record in the
customer table has been referenced
by any of those tables? example, a sql can be built based on the
relationship defined in the .gdb and used
to query into affected tables to see if referencing record exists, thanks
for any help.
Regards,
Frank