MES Stateless API

Update Method (OperItemSpec)

Save PDF

Update Method (OperItemSpec)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The Update() method updates all columns of the specified operation item specification record in the Oper_Item_Spec table.

Syntax

'Declaration
 
Public Shared Sub Update( _
   ByVal sessionId As Integer, _
   ByVal rowId As Integer, _
   ByVal processId As String, _
   ByVal operId As String, _
   ByVal stepNo As Integer, _
   ByVal itemId As DBString, _
   ByVal itemClassId As DBString, _
   ByVal verId As String, _
   ByVal specId As String, _
   ByVal specValue As String, _
   ByVal assocFile As DBString, _
   ByVal assocFileType As DBString, _
   ByVal comments As DBString, _
   ByVal minValue As DBString, _
   ByVal maxValue As DBString, _
   ByVal accessLevel As DBInt, _
   ByVal lastEditComment As DBString, _
   ByRef lastEditAt As Date _
)

'Usage
 
Dim sessionId As Integer
Dim rowId As Integer
Dim processId As String
Dim operId As String
Dim stepNo As Integer
Dim itemId As DBString
Dim itemClassId As DBString
Dim verId As String
Dim specId As String
Dim specValue As String
Dim assocFile As DBString
Dim assocFileType As DBString
Dim comments As DBString
Dim minValue As DBString
Dim maxValue As DBString
Dim accessLevel As DBInt
Dim lastEditComment As DBString
Dim lastEditAt As Date
 
OperItemSpec.Update(sessionId, rowId, processId, operId, stepNo, itemId, itemClassId, verId, specId, specValue, assocFile, assocFileType, comments, minValue, maxValue, accessLevel, lastEditComment, lastEditAt)

public static void Update( 
   int sessionId,
   int rowId,
   string processId,
   string operId,
   int stepNo,
   DBString itemId,
   DBString itemClassId,
   string verId,
   string specId,
   string specValue,
   DBString assocFile,
   DBString assocFileType,
   DBString comments,
   DBString minValue,
   DBString maxValue,
   DBInt accessLevel,
   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 unique row ID that was assigned to this record when it is added.

processId

Required. Holds the ID of the process.

operId

Required. Holds the ID of the operation.

stepNo

Required. Holds the number of the step with which the specification is associated. The default is -1, which means the specification is not associated with a step.

itemId

Required. Holds the ID of the item.

itemClassId

Required. Holds the ID of the item class.

verId

Required. Holds the specification version.

specId

Required. Holds the specification ID.

specValue

Required. Holds the specification value.

assocFile

Required. Holds the path and file name of the file associated with this specification.

assocFileType

Required. Holds the file type of the file associated with this specification.

comments

Required. Holds the comments or instructions to the operator regarding the specification.

minValue

Required. Holds the minimum acceptable value for the specification. The default is null, which means no minimum value is defined.

maxValue

Required. Holds the maximum acceptable value for the specification. The default is null, which means no maximum value is defined.

accessLevel

Required. Holds the security access level required to modify the specification. The default is null, which means no extra security is defined (null has same meaning as value = 0).

lastEditComment

Required. Holds comments that describe why this record is being added.

lastEditAt

Optional. Holds the date/time when this record was added or 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.

MES Stateless API