Event.Form.ShowDataTable(Table)

.ShowDataTable(Table) shows results of a table object. Once you get data table object, to see results on screen use the .ShowDataTable(Table). This will show all rows and columns contained in the table object. This is equivalent to clicking on the the ellipsis in a grid layout and choosing Show All Fields.

Note: Unlike the GetDataTable(TableName) there is not a Script object equivalent to show the data table. For this, you must use the Event.Form object

Applies To

Properties and Methods

None

Available

The .ShowDataTable(Table) method is available in:

  • 15.03.016
  • All newer builds

Note: The .ShowDataTable(Table) method and all sub-classes, properties, and methods are only available in Form Layout scripts.

Type

Method

Syntax

Event.Form.ShowDataTable(Table);

Parameters

Parameter

Required

Description

Table

Yes

This is a table object, not the table name.

Example

/--add this script to an event on the NewOrd1 form layout

var loTable = Script.GetDataTable('eTORD');

Event.Form.ShowDataTable(loTable);

 

/* Expected Prompt response:

.ShowDataTable() will open the Show All Fields Form with all the fields and data rows in the specified table.

*/