Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
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
Suivant
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