Toad World® Forums

Compare before and after values

OK, So the code unit I wish to test is a simple update on a single record.

The code will take the current value and add 100 to it.

In my test definition, I want to get the value before I do the update and then verify that the current value in the table = original value + 100

This sounds simple but I can’t figure out how to tell Code Test to get the original value and how to code this as an outcome.

Any help will be much appreciated.



Hi Duncan,

please refer to this thread, my reply on 2 Mar 2015 at 11:37am:

I believe you could use the global variable approach in your case as well.

Best regards,