what i want is to use for each row to loop over the currentDT
use if activity , to set condition to check if there is empty field, then use " throw" activity for exception.
and have a message box to notify which row item is empty? (like BA REF.CODE & BA PIC are empty, please fill in)
i will need to have this kind of verification check point before send email to notify for delivery.
but now my problem is i can only use the string null condition to check and detect the row item one by one, and throw exception.
so if let said my first activity is to check for DELIVERY DATE column, and it is empty then it will throw for exception and wont proceed for next checking.
even i set the throw exception to be in the end of the checking, i still dont know how to get the message box to show which row item is null when there is more than one.
hope above clarifiy.
i dont think for case use filter data table can help.