Update(Int32,String,String,String,String,String,String,Double,DBDateTime,DBDateTime,Int32,Int32,String,String,String,Boolean,Boolean,Boolean,Boolean,DBString,DBString,DBInt,String,String,String,String,String,String) Method
- Last UpdatedNov 06, 2025
- 4 minute read
The Update() method updates all columns for the specified work order record in the WO table.
'Declaration
Public Overloads Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal woId As String, _
ByVal woDesc As String, _
ByVal processId As String, _
ByVal bomVerId As String, _
ByVal specVerId As String, _
ByVal itemId As String, _
ByVal reqqty As Double, _
ByVal releaseTimeLocal As DBDateTime, _
ByVal reqFinishTimeLocal As DBDateTime, _
ByVal stateCd As Integer, _
ByVal woPriority As Integer, _
ByVal custInfo As String, _
ByVal moId As String, _
ByVal notes As String, _
ByVal notDeletable As Boolean, _
ByVal disassembly As Boolean, _
ByVal mayOverrideRoute As Boolean, _
ByVal overrideSerialization As Boolean, _
ByVal inputWOId As DBString, _
ByVal inputOperId As DBString, _
ByVal inputSeqNo As DBInt, _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal lastEditComment As String, _
ByRef modId As String _
)
'Usage
Dim sessionId As Integer
Dim woId As String
Dim woDesc As String
Dim processId As String
Dim bomVerId As String
Dim specVerId As String
Dim itemId As String
Dim reqqty As Double
Dim releaseTimeLocal As DBDateTime
Dim reqFinishTimeLocal As DBDateTime
Dim stateCd As Integer
Dim woPriority As Integer
Dim custInfo As String
Dim moId As String
Dim notes As String
Dim notDeletable As Boolean
Dim disassembly As Boolean
Dim mayOverrideRoute As Boolean
Dim overrideSerialization As Boolean
Dim inputWOId As DBString
Dim inputOperId As DBString
Dim inputSeqNo As DBInt
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditComment As String
Dim modId As String
WO.Update(sessionId, woId, woDesc, processId, bomVerId, specVerId, itemId, reqqty, releaseTimeLocal, reqFinishTimeLocal, stateCd, woPriority, custInfo, moId, notes, notDeletable, disassembly, mayOverrideRoute, overrideSerialization, inputWOId, inputOperId, inputSeqNo, spare1, spare2, spare3, spare4, lastEditComment, modId)
public static void Update(
int sessionId,
string woId,
string woDesc,
string processId,
string bomVerId,
string specVerId,
string itemId,
double reqqty,
DBDateTime releaseTimeLocal,
DBDateTime reqFinishTimeLocal,
int stateCd,
int woPriority,
string custInfo,
string moId,
string notes,
bool notDeletable,
bool disassembly,
bool mayOverrideRoute,
bool overrideSerialization,
DBString inputWOId,
DBString inputOperId,
DBInt inputSeqNo,
string spare1,
string spare2,
string spare3,
string spare4,
string 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
- Required. Holds the work order description.
- processId
- Required. Holds the ID of the process from which the work order was generated, if the work order was generated from a process.
- bomVerId
- Required. Holds the work order's BOM version ID.
- specVerId
- Required. Holds the work order's specification version ID.
- itemId
- Required. Holds the ID of the item for the work order.
- reqqty
- Required. Holds the required item quantity.
- releaseTimeLocal
- Required. Holds the entity's local date/time when the work order will be released.
- reqFinishTimeLocal
- Required. Holds the entity's local date/time by when the work order must be completed.
- stateCd
Required. 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
- Required. Holds an integer that identifies the priority for the work order.
- custInfo
- Required. Holds the work order's customer information.
- moId
- Required. Holds the manufacturing order for the work order.
- notes
- Required. Holds notes about the work order.
- notDeletable
- Required. Holds a flag that, if set to true, specifies that the work order cannot be deleted.
- disassembly
- Required. Holds a flag that, if set to true, indicates that the work order is disassembling something.
- mayOverrideRoute
- Required. 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
- Required. 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
- Required. 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
- Required. 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
- Required. 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
- Required. Holds the contents of the user-defined spare1 field.
- spare2
- Required. Holds the contents of the user-defined spare2 field.
- spare3
- Required. Holds the contents of the user-defined spare3 field.
- spare4
- Required. Holds the contents of the user-defined spare4 field.
- lastEditComment
- Required. 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. If it is specified, 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.