Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Theoretical issue - how do you handle this?
Message
 
 
To
04/04/2005 12:46:06
Donald Lowrey
Data Technology Corporation
Las Vegas, Nevada, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01001223
Message ID:
01001265
Views:
15
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform