Secret ingredients to quality software


Menu - Do you include a "Tools | Validate Data"?

Created on 27 Nov 2012 | Last updated by Rebecca Liu on 27 Nov 2012 02:54 AM (over 8 years ago)

A common oversight is applications don't check for invalid data. You should add "Tools | Validate Data" to your application.

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

Do you validate each "Denormalized Field" with procValidate?

We open source. This page is on GitHub