Update Method (Line)
- Last UpdatedNov 06, 2025
- 3 minute read
The Update() method updates all columns for the specified line record in the Line table.
'Declaration
Public Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal lineId As Integer, _
ByVal lineName As String, _
ByVal lineClass As Boolean, _
ByVal originLineClassId As DBInt, _
ByVal laborLoad As DBInt, _
ByVal maxWO As Integer, _
ByVal prodEntId As DBInt, _
ByVal prodUnitOfMeasure As Integer, _
ByVal batchSize As Double, _
ByVal stdItemId As DBString, _
ByVal bottleneckEntId As DBInt, _
ByVal targetUtil As DBDouble, _
ByVal targetQuality As DBDouble, _
ByVal targetPerformance As DBDouble, _
ByVal targetOee As DBDouble, _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal lastEditComment As DBString, _
ByRef lastEditAt As Date _
)
'Usage
Dim sessionId As Integer
Dim lineId As Integer
Dim lineName As String
Dim lineClass As Boolean
Dim originLineClassId As DBInt
Dim laborLoad As DBInt
Dim maxWO As Integer
Dim prodEntId As DBInt
Dim prodUnitOfMeasure As Integer
Dim batchSize As Double
Dim stdItemId As DBString
Dim bottleneckEntId As DBInt
Dim targetUtil As DBDouble
Dim targetQuality As DBDouble
Dim targetPerformance As DBDouble
Dim targetOee As DBDouble
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
Line.Update(sessionId, lineId, lineName, lineClass, originLineClassId, laborLoad, maxWO, prodEntId, prodUnitOfMeasure, batchSize, stdItemId, bottleneckEntId, targetUtil, targetQuality, targetPerformance, targetOee, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)
public static void Update(
int sessionId,
int lineId,
string lineName,
bool lineClass,
DBInt originLineClassId,
DBInt laborLoad,
int maxWO,
DBInt prodEntId,
int prodUnitOfMeasure,
double batchSize,
DBString stdItemId,
DBInt bottleneckEntId,
DBDouble targetUtil,
DBDouble targetQuality,
DBDouble targetPerformance,
DBDouble targetOee,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString lastEditComment,
ref DateTime lastEditAt
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- lineId
- Required. Holds the ID of the line or line class that is being updated.
- lineName
- Required. Holds the new name for the line or line class.
- lineClass
- Required. Holds the flag that specifies whether or not this is a line class.
- originLineClassId
Required. Holds the ID of the line class to which this line belongs. If null and the lineClass flag is false, this line will not be part of a line class. If null and the lineClass flag is true, this record defines a line class.
- laborLoad
- Required. Holds the number of people required to run the line that is reported to ERP.
- maxWO
- Required. Holds the maximum number of simultaneous work orders permitted on the line.
- prodEntId
- Required. Holds the ID of the entity that is the source for the production amount of the line.
- prodUnitOfMeasure
- Optional. Holds the standard production rate unit of measure for reporting the production rate.
- batchSize
- Required. Holds the standard batch size for reporting the production rate.
- stdItemId
- Required. Holds the standard item to use for reporting the production rate.
- bottleneckEntId
- Required. Holds the identity of the entity which is designted as the bottleneck of the line.
- targetUtil
- Required. Holds the KPI target for utilization (availability).
- targetQuality
- Required. Holds the KPI target for quality.
- targetPerformance
- Required. Holds the KPI target for performance.
- targetOee
- Required. Holds the KPI target for OEE.
- spare1
- Required. Holds new content for the spare1 field.
- spare2
- Required. Holds new content for the spare2 field.
- spare3
- Required. Holds new content for the spare3 field.
- spare4
- Required. Holds new content for the spare4 field.
- lastEditComment
- Required. Holds comments about why this record is being changed.
- lastEditAt
Optional. Holds the date/time when this record was added or last edited, for optimistic concurrency control. If it is specified, the passed value must match the lastEditAt value in the record for the update to succeed. If a null value is passed, then optimistic concurrency will not be used.
Output. Holds the date/time value when this record was updated by this method.