Mike Sue-Ping
Cambridge, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hilmar,
I am definitely interested in seeing how you do your validation code and would greatly appreciate any that you care to share. The stuff about corresponding error messages is what I'm now curious about too.
Mike.
>>Dana,
>>
>>Of course. You're correct in that DO CASE... is not what I'd need and several IF statements would be required. Anyway, if there were multiple fields that needed validating, is it recommended or common to create "large" IF statements within the validation rule?
>
>A table-based approach for validation is much easier to maintain. All rules, and the corresponding texts, are in a table. Then, all you need to do is add a rule and its corresponding error message into the table.
>
>If you are intested, I will post my validation code.
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