I would like to have one more feature in PHPMaker, extremely usefull: to have control on database referential integrity from Application level, which means - from PHPMaker.
Of course there should be DB Integrity Constraints defined at Database level, in database. But, we can suppose that many of PHPMaker-Users don't know how to handle full DB administration. And this is the reason why PHPMaker (succesfully) handles many other controls (default, required, null)... From PHPMaker it should be so easy and so powerfull!
Here is my example for Data Integrity control on "DELETE" for Master record - PHPMaker User should simply choose from options like:
- RESTICT deletion (no deletion of Master record if detail record(s) exist)
- NULLIFY all detail records (and delete Master record)
- CASCADE delete (or update) all detail records
- ORPHAN (delete only Master record, leave all Detail records - this is what we have now in PHPMaker ba default)
Thank You in advance. Regards to all.