When you can define a stored procedure or service query, you can define a mask for each parameter that passes between Cora SeQuence and the stored procedure or service query. The mask enables you to indicate what type of parameter it is, so that automatic operations perform correctly during execution, such as how to display a grid or paging for a combo box.
Masks can map data that is calculated automatically, such as the page size, total items, and page index of a grid or combo box. Such parameters enable grid and combo box controls to provide paging functionality. You can assign masks to other parameters manually, such as field input parameters.
| Mask Type | Description |
|---|---|
| Filter | Automatic parameter that extracts text from a combo box. Cora SeQuence uses the text entered to filter the combo box's data. |
| In | Input parameter you must supply manually. You can provide it as a default value. If you do not provide it as a default value, you must provide it as a WHERE parameter in the stored procedure. If you do not provide a value using either of these methods, the system applies a default value of NULL. |
| InOut | Parameter that is both In and Out. |
| ItemKey1 | Used to send a record according to key, for example, a default value of a combo box. Parameter retrieval is determined by primary key. |
| ItemKey2 | A primary key can have several columns. This is the second column. |
| ItemKey3 | The primary key's third column. |
| Out | Parameter that is Out. Generally, you do not need to map this parameter. |
| PageIndex | An automatic parameter that represents page index. This mask is zero based, so the page index begins with zero. |
| PageIndexOneBased | Same as the PageIndex parameter, but the index starts with 1 in the data source. |
| PageSize | An automatic parameter that represents the page size. |
| ReturnValue | Results of the stored procedure or service. |
| Sort | Represents a sort, such as a sorting grid. This parameter is taken from the control and passed to the query. |
| StartItemIndex | An automatic parameter that defines the row to start paging from. For example, a combo box with 30 results and a StartItemIndex value of 11 has the following paging: 1-10, 11-20, 21-30. |
| TotalItemCount | Total number of records. |
| Unspecified | Default mask when no mask is specified. |
