Select Table Row

This action allows you to define which row in a Database Table form object is selected. It works as a counterpart of the Get Selected Table Row action.

About group identifies the selected action.

• Name: allows you to define a custom action name. This makes actions easily recognizable on the solution's list of actions. By default, the action name is taken from its type.
• Description: custom information about the action. Enter a description to explain the purpose and role of action in a solution.
• Action type: read-only information about the selected action type.

Form Table group allows you to choose the Database Table object on the form, and select the mode under which the row in the chosen table is selected.

• Table: defines which Database Table object on the form is used with this action.

• Selection mode: defines database record selection mode.

  • First row: selects the first row in the Database Table object.

  • Last row: selects the last row in the Database Table object.

  • Row number: enables custom selection of a database table rows. Enter the row numbers or define them dynamically using a data source. To select multiple rows, enter their row numbers separated by commas.

  • Field value: selects all records in the database table with matching data value.

    • Table field: database field with value(s) that are selected in case of a match.

    • Field value: value which selects the row (record) in case of a match.

  Note

  Row number and Field value options select the table row without regard to the current sorting of table rows. For example, "row number 3" remains selected even if table sorting repositions the "row number 3" to any other row.

  • Select all rows: selects all rows in the table.

  • Deselect all rows: deselects all rows in the table.

  Note

  Multiple rows are selected if the table supports it. If not, only the first row is selected.

When selecting a table row, the row number can be stored in a variable. To enable this option, use the Store selected row number to variable option in Database Table properties.

Action Execution and Error Handling

Each action can be set as a conditional action. Conditional actions only run when the defined conditions allow them to be run. To define these conditions, click Show execution and error handling options.

Execution options are:

• Enabled: specifies if the action is enabled or disabled. Only enabled actions will execute. This functionality may be used while testing a form.
• Condition: defines one-line programming expression that must provide a Boolean value (true or false). When the result of the expression is true, the action will execute. Condition offers a way to avoid executing actions every time.

Error handling options are:

• Ignore failure: specifies whether an error should be ignored. If enabled, the execution of actions continues even if the current action fails.

  Note

  Nested actions that depend on the current action do not execute in case of a failure. The execution of actions continues with the next action on the same level as the current action. The error is logged but does not break the execution of the action.

Example

At the end of printing, you might want to send the status update to an external application using the HTTP Request action. If the printing action fails, action processing stops. In order to execute the reporting even after the failed print action, the Print Label action must have the option Ignore failure enabled.

• Save error to variable: allows you to select or create a variable to save the error to. The same cause of the error is also saved to internal variables ActionLastErrorId and ActionLastErrorDesc.