child relationships)

Derek Hohls

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Data integrity for relational databases (parent/child relationships)

I would be interested in hearing what strategies people have adopted to
ensure data integrity for relational databases...

eg. I have a customer table which can be edited --- but if some of these
customers have orders linked to them, what mechanisms can I use to
prevent accidental (or any?!) deletion of the "parent" record??

Thanks
Derek.
---
dho...@csir.co.za (remove NOSPAM. in header to repl)
variables are irrelevant. functions are useless.
prepare to be encapsulated...

T Stor

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Data integrity for relational databases (parent/child relationships)

One word: Oracle; or any other server database has foreign key abilities,
even Paradox does.

Quote

Derek Hohls wrote in message <343E0CD3.4...@csir.co.za>...
>I would be interested in hearing what strategies people have adopted to
>ensure data integrity for relational databases...

>eg. I have a customer table which can be edited --- but if some of these
>customers have orders linked to them, what mechanisms can I use to
>prevent accidental (or any?!) deletion of the "parent" record??

>Thanks
>Derek.
>---
>dho...@csir.co.za (remove NOSPAM. in header to repl)
>variables are irrelevant. functions are useless.
>prepare to be encapsulated...

Other Threads

1. Data-aware TOutline component supporting cascaded parent-child relationships

2. Using TTreeView with DB for parent/child relationship

3. help needed. in parent/child relationship , thanx

4. Business Object Parent / Child relationships

5. Parent/Child Relationships

6. Master-detail vs. Parent-child referential integrity

7. Parent-Child with a unique child identifier

8. MDI child, notification of parent's form main menu , when child form is closing

9. Relational Databases possible with Database Desktop?!?

10. No parent table on referential integrity dialog