UpdateSpecific Method (Line)
- Last UpdatedNov 06, 2025
- 3 minute read
The UpdateSpecific() method updates selected columns of the specified line record in the Line table.
'Declaration
Public Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal lineId As Integer, _
ByVal lineName As String, _
ByVal lineClass As Nullable(Of Boolean), _
ByVal originLineClassId As DBInt, _
ByVal laborLoad As DBInt, _
ByVal maxWO As Nullable(Of Integer), _
ByVal prodEntId As DBInt, _
ByVal prodUnitOfMeasure As Nullable(Of Integer), _
ByVal batchSize As Nullable(Of 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 Nullable(Of Date) _
)
'Usage
Dim sessionId As Integer
Dim lineId As Integer
Dim lineName As String
Dim lineClass As Nullable(Of Boolean)
Dim originLineClassId As DBInt
Dim laborLoad As DBInt
Dim maxWO As Nullable(Of Integer)
Dim prodEntId As DBInt
Dim prodUnitOfMeasure As Nullable(Of Integer)
Dim batchSize As Nullable(Of 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 Nullable(Of Date)
Line.UpdateSpecific(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 UpdateSpecific(
int sessionId,
int lineId,
string lineName,
Nullable<bool> lineClass,
DBInt originLineClassId,
DBInt laborLoad,
Nullable<int> maxWO,
DBInt prodEntId,
Nullable<int> prodUnitOfMeasure,
Nullable<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 Nullable<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 being updated.
- lineName
- Optional. Holds the name for the line or line class.
- lineClass
- Optional. Holds a flag specifying whether this is a line class.
- originLineClassId
- Optional. 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
- Optional. Holds the number of people required to run this line that is reported to ERP.
- maxWO
- Optional. Holds the maximum number of simultaneous work orders permitted on the line.
- prodEntId
- Optional. Holds the ID of the entity that is the source of the production amount of the line.
- prodUnitOfMeasure
- Optional. Holds the standard production rate unit of measure for reporting the production rate.
- batchSize
- Optional. Holds the standard batch size for reporting the production rate.
- stdItemId
- Optional. Holds the standard item to use for reporting the production rate.
- bottleneckEntId
- Optional. Holds the identity of the entity which is designated as the bottleneck of the line.
- targetUtil
- Optional. Holds the KPI target for utilization (availability).
- targetQuality
- Optional. Holds the KPI target for quality.
- targetPerformance
- Optional. Holds the KPI target for performance.
- targetOee
- Optional. Holds the KPI target for OEE.
- spare1
- Optional. Holds user-defined content for the spare1 field.
- spare2
- Optional. Holds user-defined content for the spare2 field.
- spare3
- Optional. Holds user-defined content for the spare3 field.
- spare4
- Optional. Holds user-defined content for the spare4 field.
- lastEditComment
- Optional. 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.
Observe the following input parameter rules:
- Optional non-DB* parameters: Either enter a new value or leave the existing value unchanged by passing a null.
- Optional DB* parameters: To clear the existing value and enter an empty value, pass DB*.null (e.g., DBInt.null). To leave the existing value unchanged, pass a null.