Skip to main content

TableDefine

The TableDefine function allows you to create a SFHub Table.

Prototype

    TableDefine(TableName ; ColumnName; ColumnType; ...)

Arguments

    TableName       String      By value   

Argument contains the name of the table to be created.

ColumnName String By value

Argument that contains the name of the first column.

ColumnType String By value

Argument that contains the data type assigned to the first column. Column types are qualified using
following notation:

- Empty string ('') for string type
- Numeric (0) for numeric type

A variable number of pairs (ColumnName and ColumnType) is accepted to create multiple columns.

Returns

    DataTable

Exception

    Undefined

Undefined is returned if one of the two arguments is not a valid string.

Example 

    $$myTable = TableDefine('myTable'; 'Column1'; ''; 'Column2'; 0)

This will return a table with two columns where Column1 is of type string and Column2 is of type numeric]. The table is assigned to the variable $$myTable.