Skip to main content

TableDynamicInsert

The TableDynamicInsert function works like the TableInsert, but if the table is empty (empty rows), all column data types will be inherited from passed values.

tip

If the table is NOT empty, column data types will not be re-assigned.

Prototype

    TableDynamicInsert(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 ​

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

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

If the table is empty:

  • Column1 data type will be a string

  • Column2 data type will be a number

  • Column3 data type will be a number

Last updated on