Get Selected Table Row

This action enables you to retrieve the numbers of selected rows, or selected field values in the Database Table form object. The values are stored in an existing or newly created variable. Get Selected Table Row action works as a counterpart of the Select 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 to select which values should be stored in a variable.

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

    • Selected row numbers: stores numbers of selected table rows in the Selected rows variable.

    • Table field content for selected rows: stores the field-related value of selected table rows.

      • Table field: defines the table field from which the values are taken and stored in the Selected rows variable.

    Note

    If multiple rows are selected, the stored values (row numbers or field values) are separated by commas. To enable multiple row selection, open Database Table object properties > Settings an enable multiple row selection.

    Note

    If the stored values (row numbers or field values) contain comma, they are surrounded with quotation marks.

  • Selected rows variable: selects or creates a variable that stores the Table field or Selected row numbers value.

Tip

Use this variable as a data source to display the selected values in a form object.

Tip

To display the selection of record immediately after the form is run, use the On Form Load event. Go to Form Properties > Events > On Form Load and click Actions.... Add Select Table Row action and define the rows as explained in this section.

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.