Script.GetDataTable(TableName).AddIntegerColumn(Name)

.AddIntegerColumn(Name) adds a column to the data table or grid with the Name provided that will hold integer numeric values. Any decimal portions of a number added to Integer columns will be truncated. Deacom best practice recommends starting the name of these columns with 's_' to differentiate them from Deacom fields, user-defined fields, and calculated fields. This will indicate to users that the column is scripted.

Note: Certain Deacom integers are too big to store as integers in Deacom scripting and must be stored as decimals instead. These are the Sales and Purchase Order numbers.

Applies To

• Event.Form.MainGrid.Results
• Event.Form.Parent.MainGrid.Results
• Event.Form.Parent.GetDataTable([TableName])
• Event.Form.Parent.Grids(FID).Results
• Event.Form.GetDataTable([TableName])
• Event.Form.Grids(FID).Results
• Inventory.LotExplosion(Lots[, View, EndDate, NegativeLots, ByProducts])
• Parameters.Results
• Query.GetTable(Query)
• Script.GetDataTable(TableName)

Properties and Methods

None

Available

The .AddIntegerColumn(Name) method is available in:

• 15.03.016
• All newer builds

Type

Method

Syntax

Script.GetDataTable(TableName).AddIntegerColumn(Name);

Parameters

Parameter	Required	Description
Name	Yes	A unique name used to identify this column. Deacom recommends starting these columns with 's_' to distinguish them from Deacom, User-defined, and calculated fields.

Example