Toad World® Forums

Outcomes - add row count with predicate



One of the Code Tester outcomes that I use a lot is the count of table rows (e.g. select Table and specify Count Before = After, etc). This is very useful in testing INSERT and DELETE operations. However, I use INACTIVATE functions just as much. In order to check the outcome of the INACTIVATE functions, I need to write a bit of custom code.

Would it be possible to add a Table row count outcome that allows you to specify a simple where clause? For example, Table Row Count Before = After Where ACTIVE = TRUE.

Just a thought.


This is a fine idea and I will add it to the ER list.

In the meantime, you can simply create a query test that accomplishes the same thing.