Table steering examples
The following examples refer to the table below containing simple personal data. The last row does not contain any data, and each cell of this row contains an embedded textbox.
Table containing personal data
For detailed information on table steering, see chapter "Table".
Example 1 - Selecting a row with a fixed position
In a table, row 3 is selected. We will now verify whether the value Jones exists in the column Last name of this row.
Verifying the value of a cell You can also use the property Text to verify cell values:
Verifying a cell value by using the property Text |
Example 2 - Selecting rows by using values in specific cells
A row, which has the attribute First name including the value Julia and the attribute Last name including the value Jones, is searched for in a table. In the row which contains these values, the engine should verify whether the attribute Date of birth including the value 9/26/1977 exists.
Verifying a value |
Example 3 - Selecting a row by value
A cell, which contains the value 10/5/1966, should be searched in a table. In the row that contains this value, the engine verifies whether the attribute First name contains the value Jane and whether Last name contains the value Miller.
Verifying values |
Example 4 - Selecting a specific row when there are several equal entries
In the table, the second row with the attribute First name including the value Peter and the attribute Last name including the value Smith, is searched for. The value #2 has to be entered for the selection. In this row, the engine should verify whether the attribute Date of birth has the value 1/3/1901.
Verifying values 2 |
Example 5 - Selecting the last row and entering values into embedded controls
The engine searches for the last row of the table using the syntax $last. The attributes First name including the value Marc, Last name including the value Walker and Date of birth including the value 12/24/1980, should be entered into this row. Each one of these cells contains an embedded textbox.
Entering values into the last row |
Example 6 - Verifying the number of rows
The property RowCount is used to verify whether a table has 7 rows. The header is included in the search query.
Verifying the number of rows |
Example 7 - Selecting the cell of a column
The engine verifies whether the value Smith exists in row 2 of the Last name column.
Verifying a value |
Example 8 - Saving the value of a cell to a buffer
The value that is located in the fourth row of the Last name column is written to the buffer Buffer1.
Buffering values in Buffer1 |
Example 9 - Steering controls with decisive columns
The system performs a click into a cell by using the table below.
Sample table FirstEmptyRow The column February is defined as decisive for control steering (decisive column). As a result, the system searches the February column for the first empty cell, and it clicks into the cell containing the value $241.10 of the same row in the January column.
FirstEmptyRow LastContentRow The column February is defined as decisive for control steering (decisive column). As a result, the system searches the February column for the last cell that includes a value, and it clicks into the cell containing the value $30.00 of the same row in the January column.
LastContentRow Defining several decisive columns If several decisive columns exist in a workspace, the FirstEmptyRow columns are linked with a logical AND, and the LastContentRow columns with a logical OR. The January and February columns are defined decisive for control steering. In row 3, both columns are empty. Therefore, the system clicks into the cell containing the value Food of the December column.
FirstEmptyRow with multiple decisive columns |
Example 10 - Buffering the row number
The property RowNumber is used to verify the row number in a table. In this example, the row number of the FirstName row is written to the buffer Buffer_row_number:
Buffering row number values |