The <sql-column> element is contained in a <sql-row> element and specifies the expected data returned in that column. The <sql-column> element can specify the name of the column whose data is to be verified. Alternately, the <sql-row> element can contain <sql-column> elements with no name specification, in which case the data in the columns of the record must be in the same order as the <sql-column> elements within the <sql-row>. If the data specified in the <sql-columnm> elements contents does no match the data in the column within the row of the return set a script error is thrown.
| Name | Description | Data Type | Default Value | Required |
|---|---|---|---|---|
| name | This attribute can specify the name of the column within the record of the return set whose data is to be verified by the <sql-column> element. If this attribute is omitted, the <sql-column> elements must match the order of the columns in the rows of the return set or a script error is thrown. Note the either all <sql-column> elements within the same <sql-row> must specify the name attribute, or none of them can. | String | None | No |