Mike Sue-Ping
Cambridge, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only