Update Method (ResultAttr)
- Last UpdatedNov 06, 2025
- 2 minute read
The Update() method updates all the columns of the specified result attribute record in the result_attr table.
'Declaration
Public Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal sampleId As Integer, _
ByVal charId As Integer, _
ByVal valueNo As Integer, _
ByVal attrId As Integer, _
ByVal attrValue As DBString, _
ByVal notes As DBString, _
ByVal lastEditComment As DBString, _
ByRef lastEditAt As Date _
)
'Usage
Dim sessionId As Integer
Dim sampleId As Integer
Dim charId As Integer
Dim valueNo As Integer
Dim attrId As Integer
Dim attrValue As DBString
Dim notes As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
ResultAttr.Update(sessionId, sampleId, charId, valueNo, attrId, attrValue, notes, lastEditComment, lastEditAt)
public static void Update(
int sessionId,
int sampleId,
int charId,
int valueNo,
int attrId,
DBString attrValue,
DBString notes,
DBString lastEditComment,
ref DateTime lastEditAt
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call
- sampleId
- Required. Holds the sample ID.
- charId
- Required. Holds characteristic ID.
- valueNo
- Required. Holds the value of the subgroup.
- attrId
- Required. Holds the attribute ID.
- attrValue
- Optional. Holds the value of the attribute.
- notes
- Optional. Holds the notes for the attribute.
- lastEditComment
- Optional. Holds comments about why this record is being changed.
- lastEditAt
Required. Holds the date/time when this record was added or last updated, 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 the 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.
- Required DB* parameters: Must pass a value. To enter an empty value for the parameter, pass DB*.null (e.g., DBInt.null).
The attribute value or the notes can be set to null in the database by passing DBString.Null for the attrValue or notes parameters respectively. But at least one of these field must have a non-null value. [[Reviewers: I added this statement that was in other xxxAttr Update methods. True for this method?]]