UpdateSpecific Method (ItemClass)
- Last UpdatedNov 06, 2025
- 3 minute read
The UpdateSpecific() method updates selected columns of the specified item class record in the Item_Class table.
'Declaration
Public Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal itemClassId As String, _
ByVal itemClassDesc As String, _
ByVal produced As Nullable(Of Boolean), _
ByVal consumed As Nullable(Of Boolean), _
ByVal obsolete As Nullable(Of Boolean), _
ByVal purchased As Nullable(Of Boolean), _
ByVal sold As Nullable(Of Boolean), _
ByVal lotNoFormat As DBString, _
ByVal lastLotNo As DBString, _
ByVal subLotNoFormat As DBString, _
ByVal lastSubLotNo As DBString, _
ByVal serialNoLvl As Nullable(Of Integer), _
ByVal invUniqueByJob As Nullable(Of Boolean), _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal lastEditComment As DBString, _
ByRef lastEditAt As Date _
)
'Usage
Dim sessionId As Integer
Dim itemClassId As String
Dim itemClassDesc As String
Dim produced As Nullable(Of Boolean)
Dim consumed As Nullable(Of Boolean)
Dim obsolete As Nullable(Of Boolean)
Dim purchased As Nullable(Of Boolean)
Dim sold As Nullable(Of Boolean)
Dim lotNoFormat As DBString
Dim lastLotNo As DBString
Dim subLotNoFormat As DBString
Dim lastSubLotNo As DBString
Dim serialNoLvl As Nullable(Of Integer)
Dim invUniqueByJob As Nullable(Of Boolean)
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
ItemClass.UpdateSpecific(sessionId, itemClassId, itemClassDesc, produced, consumed, obsolete, purchased, sold, lotNoFormat, lastLotNo, subLotNoFormat, lastSubLotNo, serialNoLvl, invUniqueByJob, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)
public static void UpdateSpecific(
int sessionId,
string itemClassId,
string itemClassDesc,
Nullable<bool> produced,
Nullable<bool> consumed,
Nullable<bool> obsolete,
Nullable<bool> purchased,
Nullable<bool> sold,
DBString lotNoFormat,
DBString lastLotNo,
DBString subLotNoFormat,
DBString lastSubLotNo,
Nullable<int> serialNoLvl,
Nullable<bool> invUniqueByJob,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString lastEditComment,
ref DateTime lastEditAt
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- itemClassId
- Optional. Holds the ID of the item class.
- itemClassDesc
- Optional. Holds the description of the item class.
- produced
- Optional. Holds a flag that, if set to true, specifies that this item class can have produced items.
- consumed
- Optional. Holds a flag that, if set to true, specifies that this item class can have consumed items.
- obsolete
- Optional. Holds a flag that, if set to true, specifies that this item class can have obsolete items.
- purchased
- Optional. Holds a flag that, if set to true, specifies that this item class can have purchased items.
- sold
- Optional. Holds a flag that, if set to true, specifies that this item class can have sold items.
- lotNoFormat
- Optional. Holds the format of the lot number.
- lastLotNo
- Optional. Holds the last lot number that was used for an item in this class.
- subLotNoFormat
- Optional. Holds the format of the sublot number.
- lastSubLotNo
- Optional. Holds the last sublot number that was used for an item in this class.
- serialNoLvl
- Optional. Holds the items based on the specified level.
- invUniqueByJob
- Optional. Holds a flag that, if set to true, specifies that the class' items inventories are unique by job.
- spare1
- Optional. A string value identifying the spare1 value
- spare2
- Optional. A string value identifying the spare2 value
- spare3
- Optional. A string value identifying the spare3 value
- spare4
- Optional. A string value identifying the spare4 value
- lastEditComment
- Optional. A string to specify why the record was changed
- lastEditAt
Required. 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.
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.