Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb thread: validate a value in one column of datagrid


Message #1 by "mlc" <mlcbusi@h...> on Thu, 21 Mar 2002 17:38:48
Although you have found a work around by assigning the integer Response to 0 or vbDataErrContinue, the
error message you are getting is coming from SQL trying to validate the data. If in fact your validity check within the program does
not match what is set in SQL you should check this error message otherwise the user will think they have updated the column. From my
experience the most common mistake for this error message is trying to store a null value in a field that requires something.

At 05:38 PM 3/21/2002 +0000, you wrote:
>i want to validate a value in a column of a datagrid, and when i do, i 
>just want to put out an error message and set focus on that column.  
>putting out a customized error message works when i validate it in the 
>aftercoledit event, but, then right after my message, microsofts general 
>error message pops up and when it returns to the grid, it move to the next 
>column.
>
>microsoft's message has a title 'microsoft datagrid control' and the body 
>of the messages says, 'Multiple-step operation generated errors. Check 
>each status value.'  I tried to prevent this from popping up in one other 
>event, but, then it was validating each charater entered in the column.
>
>what does this general error message mean, and how do i prevent it from 
>popping up?
>
>mlc


  Return to Index