At times, unexpected results may occur in processing for specific rows of data, where looping through many table records is needed for investigating errors. Rather than stepping through each record in a loop and reviewing watch variable values for the desired record, a break may be added to stop the Trace Debugger for the intended variable value.
If an unexpected result occurs for an employee with the last name "Tyler", with a vEmpLastName variable defined in the code, the below steps will allow you to stop code processing:
1.Launch the Trace Debugger for the code and stop where the variable vEmpLastName is already defined. You may need to step through several lines with [F10], or set a breakpoint to a line number "after" the vEmpLastName variable definition.
2.Add the vEmpLastName variable to the Watch Variable list. The vEmpLastName variable and data type must be displayed within the Watch Variable list.
3.Next, select vEmpLastName within the Watch Variable list to highlight it.
4.Then, right click on vEmpLastName within the Watch Variable panel and select "Break On..." > "Break On Variable Value" within the context menu.
5.Within the "Break On Variable Value" dialog's field, enter: Tyler
6.Click the OK button to close the dialog.
7.Now, the code processing may be continued with the [F5] key.
The loop processing will break when the vEmpLastName variable value is Tyler, and the encountered error may be investigated further.
Breaks may also be defined for watch variable when:
•the variable is created
•the variable is deleted
•the variable has a null value
•the variable value changes
•the variable value equals a specific value