Show TOC

<sql-expect>Locate this document in the navigation structure

The <sql-expect> element is used to verify the return set from a SELECT statement executed from within a <sql-command> element. The <sql-expect> is contained within the <sql-command> that executed the command. It can then specify the expected number of records in the return set. The <sql-expect> in can also contain one or more <sql-row> elements, each of which will contain one or more <sql-column> elements. The <sql-row> and <sql-column> elements will verify the expected contents of the return set of the SELECT statement. The <sql-expect> element can also specify if the order of the return set should match the order of the <sql-row> elements it contains, or merely verify the existence of the same records, regardless of order. If the return set does not match the expected return a script error is thrown.

  • <sql-row>
Contained By:
  • <sql-command>
Table 1: Attributes
Name Description Data Type Default Value Required
count This attribute can specify the expected number of records, or row, in the return set. If this attribute is not specified, the number of rows is not factored into the validation of the return set. non-negative integer none No
strictOrder This attribute specifies whether or not the order of the rows in the return set is expected to match the order of <sql-row> elements contained in the <sql-expect> This is a Boolean attribute, with true specifying the order must match, and false specifying it does not. If false is specified, the rows in the return set can be in any order related to the order of <sql-row> elements. However, all <sql-row> elements must have corresponding <records>.      
common script attributes This element includes the following common script attributes:
  • timeout
  • sleep