Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Create DataTable

Use this command to create a new, in-memory DataTable object that can be rendered in the user interface in Table or Calendar format.

Initially, a DataTable is created with structure only and you must use the Download (for DataTables) command or an ImportSpec to populate it with data. You can use the Upload (for DataTables) command to send any data changes back to the relevant App table.

Note: When using the UPLOAD command, the maximum number of open DataTables allowed at any given time is 31.

Syntax:

CREATE DATATABLE DataTableName USING "DataTableDefinition"

where:

  • DataTableName is the name to assign to the new DataTable object.
  • DataTableDefinition is the DataTable definition document (with the recommended extension .lvdtd).
    For information on creating this document, see Defining DataTable objects.

Syntax example:

CREATE DATATABLE Salaries USING "AllSalaries.lvdtd"

See also

Published:

Create DataTable

Use this command to create a new, in-memory DataTable object that can be rendered in the user interface in Table or Calendar format.

Initially, a DataTable is created with structure only and you must use the Download (for DataTables) command or an ImportSpec to populate it with data. You can use the Upload (for DataTables) command to send any data changes back to the relevant App table.

Note: When using the UPLOAD command, the maximum number of open DataTables allowed at any given time is 31.

Syntax:

CREATE DATATABLE DataTableName USING "DataTableDefinition"

where:

  • DataTableName is the name to assign to the new DataTable object.
  • DataTableDefinition is the DataTable definition document (with the recommended extension .lvdtd).
    For information on creating this document, see Defining DataTable objects.

Syntax example:

CREATE DATATABLE Salaries USING "AllSalaries.lvdtd"

See also

For an optimal Community experience, Please view on Desktop