Re: Philosopical debate about constraints

In the question of database level enforced constraints vs programmer applied constraints I go with database level constraints every time. ERP applications such as Baan, PeopleSoft and SAP end up costing companies huge overhead to straighten out the "programmer enforced" constraints. The only place to put programmed constraints is where shared data is treated differently in separate applications. In that case shared constraints are still enforced by the database but application specific constraints have to be handled per application. For testimonials just ask people who "clean" data for loading into a data warehouse which type of database they would rather load from.... -- --------------------------------------------------------- Steven Hauser email: hause011@tc.umn.edu URL: http://www.tc.umn.edu/~hause011 ---------------------------------------------------------