Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
My stand is that putting the validation in the application is good for a contained system where the only access to the data is via that single application or applications that access the data via the same methodology. We have rogue programmers who do things without thinking and many, many systems that access the same data.
My stand is also that once our horse is back in the stable, finding a way of keeping him there. ;)
>What are you saying - the idea's no good, or you're locking the stable after the horse has bolted?
>
>>Ok, but we just had another programmer do a mass update for the users via a script that didn't check for a valid/existing fax/email before he added an activity, so now our integrity is hosed.
>>
>>>Paul
>>>
>>>Whatever mechanism you have to allow the input of these values, e.g. enter fax activity button, or whatever, disable it if they don't have a fax no.? Same for the emails? Thus no admonishments if they try, etc.
>>>
>>>Terry
>>>
>>>>Just a question to get fuel for my upcoming debate. What is the best place to do data validation, a database procedure or in each disparate application that accesses the data or somewhere else? The validation I am referring goes like this...
>>>>
>>>>We have an activity table with millions of records that determines on what day we automatically generate a fax or an email. We have another table that holds all of the email addresses and fax numbers, also millions of records. We have another table that holds the company and another table that holds the contact for that company. Each company may or may not have a contact and each company/contact may or may not have a fax number or email address.
>>>>
>>>>The validation that needs to be put in place, for example, is that a "fax activity" should not be allowed to be inserted into the activity table by the user or by script if the company/contact doesn't have a fax number. Same with emails. Where should the validation occur for this?
>>>>
>>>>TIA for everyone's insight.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement