Update Method (Category)
- Last UpdatedNov 06, 2025
- 2 minute read
The Update() method updates all columns of the specified category record in the Category table.
'Declaration
Public Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal categoryId As Integer, _
ByVal categoryName As String, _
ByVal categoryDesc As DBString, _
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 categoryId As Integer
Dim categoryName As String
Dim categoryDesc As DBString
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
Category.Update(sessionId, categoryId, categoryName, categoryDesc, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)
public static void Update(
int sessionId,
int categoryId,
string categoryName,
DBString categoryDesc,
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.
- categoryId
- Required. Holds the ID of the category being updated.
- categoryName
- Required. Holds the name of the category being updated.
- categoryDesc
- Optional. Holds the description of the category.
- spare1
- Optional. Holds the contents of the user-defined spare1 field.
- spare2
- Optional. Holds the contents of the user-defined spare2 field.
- spare3
- Optional. Holds the contents of the user-defined spare3 field.
- spare4
- Optional. Holds the contents of the user-defined spare4 field.
- lastEditComment
- Required. Holds comments that describe why this record is being updated.
- lastEditAt
Optional. Holds the datetime 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. If a null value is passed, then optimistic concurrency will not be used.
Output. Holds the datetime value when the record was updated by this called method.