UpdateSpecific Method (Attr)
- Last UpdatedNov 06, 2025
- 3 minute read
The UpdateSpecific() method updates selected columns of the specified attribute record in the Attr table.
'Declaration
Public Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal attrId As Integer, _
ByVal predefined As Nullable(Of Boolean), _
ByVal dataType As Nullable(Of Integer), _
ByVal attrDesc As String, _
ByVal attrGrp As Nullable(Of Integer), _
ByVal filtr As DBString, _
ByVal entryType As Nullable(Of Integer), _
ByVal visibleInQueue As Nullable(Of Boolean), _
ByVal visibleInInv As Nullable(Of Boolean), _
ByVal lastEditComment As DBString, _
ByRef lastEditAt As Nullable(Of Date) _
)
'Usage
Dim sessionId As Integer
Dim attrId As Integer
Dim predefined As Nullable(Of Boolean)
Dim dataType As Nullable(Of Integer)
Dim attrDesc As String
Dim attrGrp As Nullable(Of Integer)
Dim filtr As DBString
Dim entryType As Nullable(Of Integer)
Dim visibleInQueue As Nullable(Of Boolean)
Dim visibleInInv As Nullable(Of Boolean)
Dim lastEditComment As DBString
Dim lastEditAt As Nullable(Of Date)
Attr.UpdateSpecific(sessionId, attrId, predefined, dataType, attrDesc, attrGrp, filtr, entryType, visibleInQueue, visibleInInv, lastEditComment, lastEditAt)
public static void UpdateSpecific(
int sessionId,
int attrId,
Nullable<bool> predefined,
Nullable<int> dataType,
string attrDesc,
Nullable<int> attrGrp,
DBString filtr,
Nullable<int> entryType,
Nullable<bool> visibleInQueue,
Nullable<bool> visibleInInv,
DBString lastEditComment,
ref Nullable<DateTime> lastEditAt
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- attrId
- Required. Holds the ID of the attribute whose record is being updated.
- predefined
- Optional. Holds a flag that, if set to true, specifies that the attribute is assigned to a set of predefined values.
- dataType
Optional. Holds the enumeration that indicates the data type of the attribute.
0 = string (less than 80 characters; the default)
1 = drop down from values defined in attr_set table
2 = integer
3 = currency
4 = color
5 = datetime
6 = floating point number
7 = percent
8 = check box
9 = non-editable
10 = time of day
11 = item reason (only if attr_grp = 3)
12 = long string (> 80 characters)
May be extended in future releases.
- attrDesc
- Optional. Holds the attribute description. The description must be unique within a given attribute group.
- attrGrp
Required. Holds the enumeration that identifies the group to which the attribute belongs.
1 = Items
2 = Entities
3 = Lots
4 = Item Classes
5 = Jobs
6 = WO
7 = Operations
8 = Processes
9 = Sublot
10 = Samples
11 = Results
12 = Lines
13 = Shifts
- filtr
- Optional. Holds the string that identifies the filter for the situations to which this attribute applies. For example, for item reason attributes, this is a reason_grp_id.
- entryType
Optional. Holds the enumeration that indicates the type of entry to allow for this attribute.
0 = value only (the default)
1 = notes only
2 = value and notes
- visibleInQueue
- Optional. Holds a flag that, if set to true, specifies that this attribute will be visible in the job queue. The default is false. It may be true only if attr_grp = 1, 5, or 6, entry_type is not 1, and data_type is not 12.
- visibleInInv
- Optional. Holds a flag that, if set to true, specifies that this attribute will be visible in the inventory. The default is false. It may be true only if attr_grp = 1 or 3, entry_type is not 1, and data_type is not 12.
- lastEditComment
- Optional. Holds comments that describe why this record is being updated.
- 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.