UpdateSpecific(Int32,String,DBString,DBString,DBString,DBString,String,Nullable<Double>,DBDateTime,DBDateTime,Nullable<Int32>,DBInt,DBString,DBString,DBString,DBString,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,DBString,DBString,DBInt,DBString,DBString,DBString,DBString,DBString,String) Method
- Last UpdatedNov 06, 2025
- 4 minute read
The UpdateSpecific() method updates selected columns for the specified work order record in the WO table. This overload of the method includes the productionScheduleId parameter.
'Declaration
Public Overloads Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal woId As String, _
ByVal woDesc As DBString, _
ByVal processId As DBString, _
ByVal bomVerId As DBString, _
ByVal specVerId As DBString, _
ByVal itemId As String, _
ByVal reqqty As Nullable(Of Double), _
ByVal releaseTimeLocal As DBDateTime, _
ByVal reqFinishTimeLocal As DBDateTime, _
ByVal stateCd As Nullable(Of Integer), _
ByVal woPriority As DBInt, _
ByVal custInfo As DBString, _
ByVal moId As DBString, _
ByVal productionScheduleId As DBString, _
ByVal notes As DBString, _
ByVal notDeletable As Nullable(Of Boolean), _
ByVal disassembly As Nullable(Of Boolean), _
ByVal mayOverrideRoute As Nullable(Of Boolean), _
ByVal overrideSerialization As Nullable(Of Boolean), _
ByVal inputWOId As DBString, _
ByVal inputOperId As DBString, _
ByVal inputSeqNo As DBInt, _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal lastEditComment As DBString, _
ByRef modId As String _
)
'Usage
Dim sessionId As Integer
Dim woId As String
Dim woDesc As DBString
Dim processId As DBString
Dim bomVerId As DBString
Dim specVerId As DBString
Dim itemId As String
Dim reqqty As Nullable(Of Double)
Dim releaseTimeLocal As DBDateTime
Dim reqFinishTimeLocal As DBDateTime
Dim stateCd As Nullable(Of Integer)
Dim woPriority As DBInt
Dim custInfo As DBString
Dim moId As DBString
Dim productionScheduleId As DBString
Dim notes As DBString
Dim notDeletable As Nullable(Of Boolean)
Dim disassembly As Nullable(Of Boolean)
Dim mayOverrideRoute As Nullable(Of Boolean)
Dim overrideSerialization As Nullable(Of Boolean)
Dim inputWOId As DBString
Dim inputOperId As DBString
Dim inputSeqNo As DBInt
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim modId As String
WO.UpdateSpecific(sessionId, woId, woDesc, processId, bomVerId, specVerId, itemId, reqqty, releaseTimeLocal, reqFinishTimeLocal, stateCd, woPriority, custInfo, moId, productionScheduleId, notes, notDeletable, disassembly, mayOverrideRoute, overrideSerialization, inputWOId, inputOperId, inputSeqNo, spare1, spare2, spare3, spare4, lastEditComment, modId)
public static void UpdateSpecific(
int sessionId,
string woId,
DBString woDesc,
DBString processId,
DBString bomVerId,
DBString specVerId,
string itemId,
Nullable<double> reqqty,
DBDateTime releaseTimeLocal,
DBDateTime reqFinishTimeLocal,
Nullable<int> stateCd,
DBInt woPriority,
DBString custInfo,
DBString moId,
DBString productionScheduleId,
DBString notes,
Nullable<bool> notDeletable,
Nullable<bool> disassembly,
Nullable<bool> mayOverrideRoute,
Nullable<bool> overrideSerialization,
DBString inputWOId,
DBString inputOperId,
DBInt inputSeqNo,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString lastEditComment,
ref string modId
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- woId
- Required. Holds the ID of the work order that is being updated.
- woDesc
- Optional. Holds the work order description.
- processId
- Optional. Holds the ID of the process from which the work order was generated, if the work order was generated from a process.
- bomVerId
- Optional. Holds the work order's BOM version ID.
- specVerId
- Optional. Holds the work order's specification version ID.
- itemId
- Optional. Holds the ID of the item for the work order.
- reqqty
- Optional. Holds the required item quantity.
- releaseTimeLocal
- Optional. Holds the entity's local date/time when the work order will be released.
- reqFinishTimeLocal
- Optional. Holds the entity's local date/time by when the work order must be completed.
- stateCd
Optional. Holds the code that indicates the state of the work order. Valid codes are:
0 = Released (the default)
1 = Started
2 = Completed
3 = Closed. When closed, nothing else for this work order is editable.
- woPriority
- Optional. Holds an integer that identifies the priority for the work order.
- custInfo
- Optional. Holds the work order's customer information.
- moId
- Optional. Holds the manufacturing order for the work order.
- productionScheduleId
- Optional. Holds the production schedule ID.
- notes
- Optional. Holds notes about the work order.
- notDeletable
- Optional. Holds a flag that, if set to true, specifies that the work order cannot be deleted.
- disassembly
- Optional. Holds a flag that, if set to true, indicates that the work order is disassembling something.
- mayOverrideRoute
- Optional. Holds a flag that, if set to true, indicates that the work order can include operations other than those immediately upstream or downstream from the current one.
- overrideSerialization
- Optional. Holds a flag that, if set to true, indicates that if the work order is producing an item that is normally serialized, the item is treated as not serialized.
- inputWOId
- Optional. Holds the work order ID of the job from which a rework work order would originate. Set to null if the work order is not created as a result of rework.
- inputOperId
- Optional. Holds the operation ID of the job from which a rework work order would originate. Set to null if the work order is not created as a result of rework.
- inputSeqNo
- Optional. Holds the operation sequence number of the job from which a rework work order would originate. Set to null if the work order is not created as a result of rework.
- spare1
- Optional. Holds the contents of the user-defined spare1 field.
- spare2
- Optional. Holds the contents of the user-defined spare2 field.
- spare3
- Optional. Holds the contents of the user-defined spare3 field.
- spare4
- Optional. Holds the contents of the user-defined spare4 field.
- lastEditComment
- Optional. Holds comments that describe why this record is being updated.
- modId
Required. Holds the modification ID assigned the last time this record was added or updated, for optimistic concurrency control. The passed value must match the record's modId for the record to be updated.
Output. Holds the new modification ID to identify this update of this record.
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.