Re: Data Constraints AND Application Constraints

"David Cressey" <david.cressey_at_earthlink.net> wrote:

>> But surely for a rule like the one above, you would also implement a
>> constraint in the db?

>Well... yes I would. But my argument about the DBMS better using it's
>resources stands.
>If it's implemented in both places, the DBMS will still experience less
>traffic, because it won't
>see the bad transactions that get snagged by the application.

But the whole point about this is that that's probably fine if you are a single developer who is writing one app against the db - your baby!

Then company gets taken over and 5 new apps are being written against the db. You've retired to the Caribbean and the new programmers don't have a clue. What happens then?

Paul...

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

if Oracle group then
db := Oracle 9.2.0.1.0;
else
db := Interbase 6.0.2.0;
endif 

As a courtesy to those who spend 
time analyzing and attempting to
help, please do not top post.