MES Stateless API

Update Method (Lot)

Save PDF

Update Method (Lot)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The Update() method updates all columns for the specified lot record in the Lot table.

Syntax

'Declaration
 
Public Shared Sub Update( _
   ByVal sessionId As Integer, _
   ByVal itemId As String, _
   ByVal lotNo As String, _
   ByVal gradeCd As DBInt, _
   ByVal statusCd As DBInt, _
   ByVal expiryDate As DBDateTime, _
   ByVal isSerialNo As Boolean, _
   ByVal spare1 As DBString, _
   ByVal spare2 As DBString, _
   ByVal spare3 As DBString, _
   ByVal spare4 As DBString, _
   ByVal spare5 As DBString, _
   ByVal spare6 As DBString, _
   ByVal lastEditComment As DBString, _
   ByRef lastEditAt As Date _
)

'Usage
 
Dim sessionId As Integer
Dim itemId As String
Dim lotNo As String
Dim gradeCd As DBInt
Dim statusCd As DBInt
Dim expiryDate As DBDateTime
Dim isSerialNo As Boolean
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim spare5 As DBString
Dim spare6 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
 
Lot.Update(sessionId, itemId, lotNo, gradeCd, statusCd, expiryDate, isSerialNo, spare1, spare2, spare3, spare4, spare5, spare6, lastEditComment, lastEditAt)

public static void Update( 
   int sessionId,
   string itemId,
   string lotNo,
   DBInt gradeCd,
   DBInt statusCd,
   DBDateTime expiryDate,
   bool isSerialNo,
   DBString spare1,
   DBString spare2,
   DBString spare3,
   DBString spare4,
   DBString spare5,
   DBString spare6,
   DBString lastEditComment,
   ref DateTime lastEditAt
)

Parameters

sessionId

Required. Holds the session ID and thus the user who is making this method call.

itemId

Required. Holds the ID of the item.

lotNo

Required. Holds the lot number of the item.

gradeCd

Required. Holds the grade code of the item.

statusCd

Required. Holds the status code of the item.

expiryDate

Required. Holds the expiry date and time of the lot, if not overridden for a sublot or a particular inventory record. This is a fixed time that is not related to a local time or UTC.

Note: This parameter is not currently used by the system.

isSerialNo

Required. Holds a flag that, if set to true, specifies that the lot is the serial number.

spare1

Required. Holds the contents of a user-defined spare1 field.

spare2

Required. Holds the contents of a user-defined spare2 field.

spare3

Required. Holds the contents of a user-defined spare3 field.

spare4

Required. Holds the contents of a user-defined spare4 field.

spare5

Required. Holds the contents of a user-defined spare5 field.

spare6

Required. Holds the contents of a user-defined spare6 field.

lastEditComment

Required. Holds comments that describes 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