Extending the PFC Multi Table Update Service

Supporting Referential Integrity / Foreign Key Constraints on Inserts and Deletes

by Stephen Pareles

Table of Contents

1. Introduction ........................................................... Page 1
2. Solutions Based on Hardcoded SQL ................... Page 1
3. Limited Solutions Without Hardcoded SQL ....... Page 1
4. Overcoming the Limitation .................................. Page 1
5. The Tables ............................................................ Page 2
6. The Constraints .................................................... Page 2
7. Interpretation of The Constraints ....................... Page 2
8. Application Objects .............................................. Page 2
9. The Solution ......................................................... Page 2
10. How the Developer Uses the New Feature ........ Page 3
11. Under the Hood .................................................... Page 3
12. References ........................................................... Page 3