5

I wrote a stored procedure and declared the input as varchar instead of varchar(100). everything seemed to be working. later on we noticed that the procedure only saved the first character of the input (a user form). unfortunately we found out first when the monthly form reports where issued. a whole month of incomplete forms from our users. the client wasn't happy.

Comments
  • 1
    Testing? It did not go through a Dev and a QA environment before production?
  • 1
    @lydeking , poorly tested. we made sure that the forms where submitted but didn't check the form values. I still can't figure out how the code could reach production, but I believe that the bug was fixed in test. but the bug fix didn't make it to production.
Add Comment