>Hi Madya
>
>The question is whether you control data entry with a rule a) enforced in the application code or b) by the database.
>
>My take is that there is no best answer, but rather a case of perspective. SQL and Oracle people will probably say use table rules. I go the otherway and try to have a business rule in the code to handle it. Why? Because I might want to switch database engines (VFP to MS SQL or mySQL). My belief is that I will have less refactoring to do if I enforce all of the rules in the application, fewer places to look when something goes wrong. Not to be misleading, I do use RI, but the triggers refer to code.
>
>- Don Lowrey
Don,
Thanks a lot for the answer. I want to gather this information from as many users from UT as possible, so when I would be able to see what is the preferred guideline here.
If it's not broken, fix it until it is.
My Blog