Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Record Validation Ideas
I have a table in a database that I need to add record validation to. The problem is that some of the fields need the validation while others do not.
For instance, My table has 10 fields. 8 of them need to pass a validation clause before they can be updated. The other 2 fields can be updated at any time.
So if a user changes data in one of the 2 fields, there is on validation, it lets him continue without any validation.
But if a user changes data in one of the 8 fields, it applys a rule.
any ideas on how to accomplish this?
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