Menu - Do you include a "Tools | Validate Data"?
SSW Rules to Better Interfaces (Windows Applications)|18cfdc56-c52b-43db-8fcc-b677e5ce4aee
v1.0
Posted at
27/11/2012 1:54 PM by
Rebecca Liu
Rule Intro
A common oversight is applications don't check for invalid data. You should add "Tools | Validate Data" to your application.
Page Content
So when you add business rules to the middle tier, consider scenarios such as importing data and any other areas that side step business rules. Therefore we always make validate queries that if they return records, they must be fixed. Examples are:
- For SQL Server we use vwValidateClient_MustHaveACategoryID, or procValidateClient_MustHaveACategoryID
- For Access we use qryValidateClient_MustHaveACategoryID
- Figure: Good Example - This application, while not the prettiest, has a handy validation tool to check for incorrect data
Related Links
{8AFBE219-50FC-439C-A866-DF3F4E085221}
Do you feel this rule needs an update?
