UpdateSpecific(Int32,Nullable<Int32>,Nullable<Int32>,DBString,Nullable<Double>,Nullable<Double>,DBString,DBString,DBString,DBString,DBString,Int32,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 2 minute read
The UpdateSpecific() method updates selected columns of the specified uom conversion record in the Uom_Conv table.
This overload of the method includes spare field parameters for updating user-defined content to the record.
'Declaration
Public Overloads Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal fromUomId As Nullable(Of Integer), _
ByVal toUomId As Nullable(Of Integer), _
ByVal itemId As DBString, _
ByVal factor As Nullable(Of Double), _
ByVal offset As Nullable(Of Double), _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal lastEditComment As DBString, _
ByVal rowId As Integer, _
ByRef lastEditAt As Nullable(Of Date) _
)
'Usage
Dim sessionId As Integer
Dim fromUomId As Nullable(Of Integer)
Dim toUomId As Nullable(Of Integer)
Dim itemId As DBString
Dim factor As Nullable(Of Double)
Dim offset As Nullable(Of Double)
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim rowId As Integer
Dim lastEditAt As Nullable(Of Date)
UomConv.UpdateSpecific(sessionId, fromUomId, toUomId, itemId, factor, offset, spare1, spare2, spare3, spare4, lastEditComment, rowId, lastEditAt)
public static void UpdateSpecific(
int sessionId,
Nullable<int> fromUomId,
Nullable<int> toUomId,
DBString itemId,
Nullable<double> factor,
Nullable<double> offset,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString lastEditComment,
int rowId,
ref Nullable<DateTime> lastEditAt
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- fromUomId
- Optional. Holds the ID of the starting unit of measure.
- toUomId
- Optional. Holds the ID of the resulting unit of measure.
- itemId
- Optional. Holds the ID of the item for which the conversion is valid. The value in the database can be set to null by passing DBString.Null.
- factor
- Optional. Holds the factor by which the quantity is multiplied. This may not be zero.
- offset
- Optional. Holds the offset added to the multiplied quantity to obtain the final result.
- spare1
- Optional. Holds user-defined content for the spare1 field.
- spare2
- Optional. Holds user-defined content for the spare2 field.
- spare3
- Optional. Holds user-defined content for the spare3 field.
- spare4
- Optional. Holds user-defined content for the spare4 field.
- lastEditComment
- Optional. Holds comments that describe why this record is being updated.
- rowId
- Required. Holds the ID of the row
- 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.
Observe the following input parameter rules:
- Optional non-DB* parameters: Either enter a new value or leave the existing value unchanged by passing a null.
- Optional DB* parameters: To clear the existing value and enter an empty value, pass DB*.null (e.g., DBInt.null). To leave the existing value unchanged, pass a null.