Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using a Database or Free Standing Tables?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00194522
Message ID:
00195594
Views:
27
>Agreed. But what is a business rule vs. a RI rule. One client may say that he
>needs to have a customer for every invoice that is entered and another may say
>that they need to be able to enter an invoice and associate it with a client
>later(idea from 'About Face').

I don't remember which MVP I stole this example from (was it you, Jim?), but say you have a numeric field to store the day of the week. A Database Rule is that the values must be between 1 and 7 (or 0 and 6, depending on how you count it). A Business Rule is that you are never open on weekends. If you put that in the database, and then have a special sale on Saturday, you have no way to enter that, because the Database won't let you.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform