TableOperator

The TableOperator function allows you to perform an operation on a table value column, for all the table rows satisfying the filter condition applied on the key column (Column Value = Column Value ( * / - +) Value).

Prototype

    TableOperator(Table; ColumnKey; Key; Operator; ColumnName; Value)

Arguments

    Table             Variable        By value   

    Argument that contains the variable of type Table.

    ColumnKey         String          By value   

    Argument is a valid string containing the name of the column key on which apply the filter condition.

    Key               Any             By value   

    Argument that contains the value used to filter the rows based on the equality with the value contained in the ColumnKey.

    Operator          String          By value  

    Argument that contains the operator to be applied to the operation. It could be one of the arithmetic operators (    + - / *    ).

    ColumnName        String          By value  

    Argument that contains valid string containing the name of the column on which to perform the operation.

    Value             Numeric         By value   

Argument that contains the value to be applied in the operation.

Returns

    Boolean

    True is returned if the function terminates successfully

Exception

    Exception Error

    Execution Error is returned in case of an invalid parameters (column name not found in the table or invalid operator).

Example 

    TableOperator($$myTable ; 'Tank'; 'tk_C4'; '/'; 'Mass'; 1000)   

This will modify the Mass column value, dividing by 1000, all the rows having the Tank column equal to [tk_C4\'].