UpdateSpecific Method (JobEvent)
- Last UpdatedNov 06, 2025
- 4 minute read
The UpdateSpecific() method updates selected columns of the specified job event record in the Job_Event table.
'Declaration
Public Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal rowId As Integer, _
ByVal eventTimeLocal As Nullable(Of Date), _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Nullable(Of Integer), _
ByVal stepNo As DBInt, _
ByVal eventType As DBString, _
ByVal entId As DBInt, _
ByVal bomPos As DBInt, _
ByVal lotNo As DBString, _
ByVal subLotNo As DBString, _
ByVal itemId As DBString, _
ByVal certName As DBString, _
ByVal doneByUserId As DBString, _
ByVal checkedByUserId As DBString, _
ByVal sourceRowId As DBInt, _
ByVal specId As DBString, _
ByVal comments As DBString, _
ByVal value1 As DBString, _
ByVal value2 As DBString, _
ByVal value3 As DBString, _
ByVal value4 As DBString, _
ByVal value5 As DBString, _
ByVal value6 As DBString, _
ByVal value7 As DBString, _
ByVal value8 As DBString, _
ByVal value9 As DBString, _
ByVal value10 As DBString, _
ByVal lastEditComment As DBString, _
ByRef lastEditAt As Date _
)
'Usage
Dim sessionId As Integer
Dim rowId As Integer
Dim eventTimeLocal As Nullable(Of Date)
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim stepNo As DBInt
Dim eventType As DBString
Dim entId As DBInt
Dim bomPos As DBInt
Dim lotNo As DBString
Dim subLotNo As DBString
Dim itemId As DBString
Dim certName As DBString
Dim doneByUserId As DBString
Dim checkedByUserId As DBString
Dim sourceRowId As DBInt
Dim specId As DBString
Dim comments As DBString
Dim value1 As DBString
Dim value2 As DBString
Dim value3 As DBString
Dim value4 As DBString
Dim value5 As DBString
Dim value6 As DBString
Dim value7 As DBString
Dim value8 As DBString
Dim value9 As DBString
Dim value10 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
JobEvent.UpdateSpecific(sessionId, rowId, eventTimeLocal, woId, operId, seqNo, stepNo, eventType, entId, bomPos, lotNo, subLotNo, itemId, certName, doneByUserId, checkedByUserId, sourceRowId, specId, comments, value1, value2, value3, value4, value5, value6, value7, value8, value9, value10, lastEditComment, lastEditAt)
public static void UpdateSpecific(
int sessionId,
int rowId,
Nullable<DateTime> eventTimeLocal,
string woId,
string operId,
Nullable<int> seqNo,
DBInt stepNo,
DBString eventType,
DBInt entId,
DBInt bomPos,
DBString lotNo,
DBString subLotNo,
DBString itemId,
DBString certName,
DBString doneByUserId,
DBString checkedByUserId,
DBInt sourceRowId,
DBString specId,
DBString comments,
DBString value1,
DBString value2,
DBString value3,
DBString value4,
DBString value5,
DBString value6,
DBString value7,
DBString value8,
DBString value9,
DBString value10,
DBString lastEditComment,
ref DateTime lastEditAt
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- rowId
- Required. Holds the row ID of the job event record to be updated.
- eventTimeLocal
- Optional. Holds the date/time that the job event occurred, in local time.
- woId
- Optional. Holds the ID of the work order for the job.
- operId
- Optional. Holds the ID of the operation for the job.
- seqNo
- Optional. Holds the sequence number for the operation.
- stepNo
- Optional. Holds the job step for this event.
- eventType
- Optional. Holds the event type used to categorize the job event.
- entId
- Optional. Holds the ID of the entity related to the event.
- bomPos
- Optional. Holds the BOM position related to the event.
- lotNo
- Optional. Holds the lot number related to the event.
- subLotNo
- Optional. Holds the sublot number related to the event.
- itemId
- Optional. Holds the ID of the item related to the event.
- certName
- Optional. Holds the name of the certification related to this event.
- doneByUserId
- Optional. Holds the ID of the user who performed an action for this event.
- checkedByUserId
- Optional. Holds the ID of the user who checked an action for this event.
- sourceRowId
- Optional. Holds the row ID of the record in the Item_Prod or Item_Cons table to which this event relates.
- specId
- Optional. Holds the ID of the specification to which this event relates.
- comments
- Optional. Holds comments about this event.
- value1
- Optional. Holds the contents of a spare field for this event.
- value2
- Optional. Holds the contents of a spare field for this event.
- value3
- Optional. Holds the contents of a spare field for this event.
- value4
- Optional. Holds the contents of a spare field for this event.
- value5
- Optional. Holds the contents of a spare field for this event.
- value6
- Optional. Holds the contents of a spare field for this event.
- value7
- Optional. Holds the contents of a spare field for this event.
- value8
- Optional. Holds the contents of a spare field for this event.
- value9
- Optional. Holds the contents of a spare field for this event.
- value10
- Optional. Holds the contents of a spare field for this event.
- lastEditComment
- Optional. Holds comments that describe why this record is being updated.
- lastEditAt
Required. Holds the date/time when this record was last updated, for optimistic concurrency control. If it is specified, the passed value must match the lastEditAt value in the record for the update to succeed.
Output. Holds the date/time value when the record was updated by this called method.
Observe the following input parameter rules:
- Optional non-DB* parameters: Either enter a value or pass a null. If passing a null and a default value has been defined, the default value will be used for the parameter.
- Optional DB* parameters: To enter no value for the parameter, pass DB*.null (e.g., DBInt.null). To use the default value for the parameter if one has been defined for the object being added, pass a null.