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.
*/