Background Tasks • Close Query field: Enter any tag; when the value of the tag changes, the cursor releases the result set. • Previous field: Enter any tag; when the value of the tag changes, the cursor moves to the previous row of the result set and copies those values to the tag configured in the worksheet body. • Total number of rows field: Enter a numeric tag that will receive the total number of rows in the result set. • Current row number field: Enter a numeric tag that will receive the number of the current row (i.e., the position of the cursor). When a result set is first opened using the Select trigger, this number is 1.
Each Next trigger increments this number, and each Previous trigger decrements it. • Table Triggers area… • Insert field: Enter any tag; when the value of the tag changes, a new row is inserted with the current values of the tags configured in the worksheet body. • Update field: Enter any tag; when the value of the tag changes, all rows of the result set are overwritten with the current values of the tags configured in the worksheet body. • Delete field: Enter any tag; when the value of the tag changes, all rows of the result set are deleted. Note: Table triggers are available only when Type is set to Table , because these operations work on the entire table row.
Worksheet Body In the body of the worksheet, you can map project tags to the columns (fields) of the result set. For each row of the body, enter a Tag Name and its corresponding Column . Which columns are available depends on how the result set is selected, and how it is selected may change during runtime, so be sure to map all necessary columns. InduSoft Web Studio Page 289