Update Method (StorageExec)
- Last UpdatedNov 06, 2025
- 4 minute read
The Update() method updates all fields for the specified storage exec record in the Storage_Exec table.
'Declaration
Public Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal entId As Integer, _
ByVal type As DBString, _
ByVal status As Integer, _
ByVal maxCapacity As DBDouble, _
ByVal uomId As DBInt, _
ByVal tare As DBDouble, _
ByVal tareUomId As DBInt, _
ByVal autoDelZeroInv As Boolean, _
ByVal allowNegQty As Boolean, _
ByVal scannableId As DBString, _
ByVal allowMultipleItems As Boolean, _
ByVal allowMultipleLots As Boolean, _
ByVal movable As Boolean, _
ByVal storageEntId As DBInt, _
ByVal allowDirtyState As Boolean, _
ByVal logStateTransitions As Boolean, _
ByVal indistinguishableLots As Boolean, _
ByVal unlisted As Boolean, _
ByVal spareInt1 As DBInt, _
ByVal spareInt2 As DBInt, _
ByVal spareInt3 As DBInt, _
ByVal spareInt4 As DBInt, _
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 entId As Integer
Dim type As DBString
Dim status As Integer
Dim maxCapacity As DBDouble
Dim uomId As DBInt
Dim tare As DBDouble
Dim tareUomId As DBInt
Dim autoDelZeroInv As Boolean
Dim allowNegQty As Boolean
Dim scannableId As DBString
Dim allowMultipleItems As Boolean
Dim allowMultipleLots As Boolean
Dim movable As Boolean
Dim storageEntId As DBInt
Dim allowDirtyState As Boolean
Dim logStateTransitions As Boolean
Dim indistinguishableLots As Boolean
Dim unlisted As Boolean
Dim spareInt1 As DBInt
Dim spareInt2 As DBInt
Dim spareInt3 As DBInt
Dim spareInt4 As DBInt
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
StorageExec.Update(sessionId, entId, type, status, maxCapacity, uomId, tare, tareUomId, autoDelZeroInv, allowNegQty, scannableId, allowMultipleItems, allowMultipleLots, movable, storageEntId, allowDirtyState, logStateTransitions, indistinguishableLots, unlisted, spareInt1, spareInt2, spareInt3, spareInt4, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)
public static void Update(
int sessionId,
int entId,
DBString type,
int status,
DBDouble maxCapacity,
DBInt uomId,
DBDouble tare,
DBInt tareUomId,
bool autoDelZeroInv,
bool allowNegQty,
DBString scannableId,
bool allowMultipleItems,
bool allowMultipleLots,
bool movable,
DBInt storageEntId,
bool allowDirtyState,
bool logStateTransitions,
bool indistinguishableLots,
bool unlisted,
DBInt spareInt1,
DBInt spareInt2,
DBInt spareInt3,
DBInt spareInt4,
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.
- entId
- Required. Holds the ID of the entity whose storage exec information is being updated.
- type
- Optional. Holds a user-defined string used for sorting.
- status
- Required. Holds the status of the storage entity.
- maxCapacity
- Optional. Holds the maximum storage capacity.
- uomId
- Optional. Holds the ID of the unit of measure for the maxCapacity parameter.
- tare
- Optional. Holds the weight of the entity when empty.
- tareUomId
- Optional. Holds the ID of the unit of measure for the tare weight.
- autoDelZeroInv
- Required. Holds a flag that, if set to true, specifies that the row from the Item_Inventory table be deleted when the quantity left is less than or equal to zero.
- allowNegQty
- Required. Holds a flag that, if set to true, specifies that negative quantity left values be allowed.
- scannableId
- Optional. Holds a flag that, if set to true, specifies that a bar code scan can be used to uniquely identify the entity.
- allowMultipleItems
- Required. Holds a flag that, if set to true, specifies that different items can be stored within this storage entity.
- allowMultipleLots
- Required. Holds a flag that, if set to true, specifies that different lot numbers can be stored within this entity.
- movable
- Required. Holds a flag that, if set to true, specifies that this storage entity is movable.
- storageEntId
- Optional. Holds another entity where this storage entity is currently located (only used when this storage entity is movable).
- allowDirtyState
- Required. Holds a flag that, if set to true, specifies that the Dirty state (status = 2) is available for this storage entity.
- logStateTransitions
- Required. Holds a flag that, if set to true, specifies that state transitions are logged for this entity.
- indistinguishableLots
- Required. Holds a flag that, if set to true, specifies that inventory stored in this entity cannot be separated by lot number when consumed, shipped, or transferred out.
- unlisted
- Required. Holds a flag that, if set to true, specifies that this entity will not show up in certain trees and lists of storage entities.
- spareInt1
- Optional. Holds the contents of the user-defined spare1 integer field.
- spareInt2
- Optional. Holds the contents of the user-defined spare2 integer field.
- spareInt3
- Optional. Holds the contents of the user-defined spare3 integer field.
- spareInt4
- Optional. Holds the contents of the user-defined spare4 integer field.
- spare1
- Optional. Holds the contents of the user-defined spare1 string field.
- spare2
- Optional. Holds the contents of the user-defined spare2 string field.
- spare3
- Optional. Holds the contents of the user-defined spare3 string field.
- spare4
- Optional. Holds the contents of the user-defined spare4 string field.
- lastEditComment
- Required. Holds the new comment that describes why this record is being updated.
- lastEditAt
Required. Holds the date/time when this record was added or last edited, for optimistic concurrency control. The passed value must match the lastEditAt value in the record for the update to succeed.
Output. Holds the date/time value when this record was updated by this called method.
Observe the following input parameter rules:
- Required non-DB* parameters: Must pass a value. Cannot be empty or null.
- 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.
- Required DB* parameters: Must pass a value. To enter an empty value for the parameter, pass DB*.null (e.g., DBInt.null).
- 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.