Hi all, I have a DW with one column as required and have Edit Mask. I made the changes in of_SetToNullIfEmpty() to include columns with Edit masks (as mentioned by Sharon Buntz at http://www.pfcguide.com). I found out that the Required Column Service will not pick that column as required value missing if the column's value is an empty string which make sense since Edit Masks do not have Empty String is Null property. That's why of_SetToNullIfEmpty() is changed to accommodate this. The problem is of_SettoNullIfEmpty() is called from u_dw's itemerror event only and in my case itemerror event is not triggering somehow. So this what i found out: This solution of Required Column Service for Edit Maks wil not work if 1. The row is new and user type data in that column and then delete it (i.e. make it an empty string) 2. The row is old and user type data in that column and then delete it (i.e. make it an empty string) 3. The row is old and that column's value is empty string and user do not touch that column It will work when 1. The row is new and user do not touch that column My question is what i am doing wrong? The solution come to my mind is to call of_SettoNullIfEmpty() for all required columns before the validation but I was thinking i may got a better solution from other people. Any suggestion will be helpful. Rizwan _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
