UpdateSpecific Method (StorageExec)
- Last UpdatedNov 06, 2025
- 4 minute read
The UpdateSpecific() method updates selected columns for the specified storage exec record in the Storage_Exec table.
'Declaration
Public Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal entId As Integer, _
ByVal type As DBString, _
ByVal status As Nullable(Of Integer), _
ByVal maxCapacity As DBDouble, _
ByVal uomId As DBInt, _
ByVal tare As DBDouble, _
ByVal tareUomId As DBInt, _
ByVal autoDelZeroInv As Nullable(Of Boolean), _
ByVal allowNegQty As Nullable(Of Boolean), _
ByVal scannableId As DBString, _
ByVal allowMultipleItems As Nullable(Of Boolean), _
ByVal allowMultipleLots As Nullable(Of Boolean), _
ByVal movable As Nullable(Of Boolean), _
ByVal storageEntId As DBInt, _
ByVal allowDirtyState As Nullable(Of Boolean), _
ByVal logStateTransitions As Nullable(Of Boolean), _
ByVal indistinguishableLots As Nullable(Of Boolean), _
ByVal unlisted As Nullable(Of 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 Nullable(Of Integer)
Dim maxCapacity As DBDouble
Dim uomId As DBInt
Dim tare As DBDouble
Dim tareUomId As DBInt
Dim autoDelZeroInv As Nullable(Of Boolean)
Dim allowNegQty As Nullable(Of Boolean)
Dim scannableId As DBString
Dim allowMultipleItems As Nullable(Of Boolean)
Dim allowMultipleLots As Nullable(Of Boolean)
Dim movable As Nullable(Of Boolean)
Dim storageEntId As DBInt
Dim allowDirtyState As Nullable(Of Boolean)
Dim logStateTransitions As Nullable(Of Boolean)
Dim indistinguishableLots As Nullable(Of Boolean)
Dim unlisted As Nullable(Of 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.UpdateSpecific(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 UpdateSpecific(
int sessionId,
int entId,
DBString type,
Nullable<int> status,
DBDouble maxCapacity,
DBInt uomId,
DBDouble tare,
DBInt tareUomId,
Nullable<bool> autoDelZeroInv,
Nullable<bool> allowNegQty,
DBString scannableId,
Nullable<bool> allowMultipleItems,
Nullable<bool> allowMultipleLots,
Nullable<bool> movable,
DBInt storageEntId,
Nullable<bool> allowDirtyState,
Nullable<bool> logStateTransitions,
Nullable<bool> indistinguishableLots,
Nullable<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
- Optional. 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
Optional. 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
- Optional. 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
- Optional. Holds a flag that, if set to true, specifies that different items can be stored within this storage entity.
- allowMultipleLots
- Optional. Holds a flag that, if set to true, specifies that different lot numbers can be stored within this entity.
- movable
- Optional. 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
- Optional. Holds a flag that, if set to true, specifies that the Dirty state (status = 2) is available for this storage entity.
- logStateTransitions
- Optional. Holds a flag that, if set to true, specifies that state transitions are logged for this entity.
- indistinguishableLots
- Optional. 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
- Optional. 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
- Optional. Holds the new comment that describes why this record is being updated.
- lastEditAt
Optional. Holds the date/time when this record was added or last edited, 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 this record was updated by this called method.