Skip to main content

TableInsert

The TableInsert function allows you to add a new row to a SFHub Table. This function requires you to set the value for each column of the table.

Prototype

    TableInsert(Table ; ColumnName; Value; ... )

Arguments

    Table             Variable      By value   

Argument contains the variable of type table.

ColumnName String By value

Argument that contains the name of the column.

Value Any By value

Argument that contains the value to be assigned to the specified column. The value could be a string
or a numeric value, according to the column data type.

A variable number of pairs (ColumnName and Value) are accepted to assign values to multiple columns.
If a column is missing, then a null value will be recorded.

Returns

    Boolean

True is returned if the function terminates successfully.

Exception

    Undefined

Undefined is returned if one of the arguments is invalid.

Example 

    TableInsert($$myTable; 'Column1'; 'aaaa'; 'Column2'; 1; 'Column3'; 1200)

This will add a new row to the table referenced by the variable $$myTable.