verifyCell task compares DB field value with given values. Task fails if comparison result is false.
| Attribute | Description | Default | Required |
| raw | Number of raw in the result of SQL execution. | None | Yes |
| field | Name of field to be verified. | None | Yes |
| value | The value to compare with. | None | Yes |
<sqlExt driver="com.jnetdirect.jsql.JSQLDriver"
url="jdbc:JSQLConnect://${DBHost}:1433/database=${DBName}"
userid="${DBUser}"
password="${DBPassword}"
query="select * from test_sqlExt order by id">
<verifyCell row = "1" field = "str_field" value = "str1"/>
<verifyCell row = "2" field = "char_field" value = "2"/>
<verifyCell row = "3" field = "date_field" value = "2008-11-27 18:23:43"/>
<verifyCell row = "3" field = "decimal_field" value = "33.33"/>
<verifyCell row = "4" field = "decimal_field" value = "-44.44"/>
</sqlExt>