UpdateSpecific Method (ItemFile)
- Last UpdatedNov 06, 2025
- 2 minute read
The UpdateSpecific() method updates selected columns for the specified item file record in the Item_File table.
'Declaration
Public Shared Sub UpdateSpecific( _
ByVal sessionId As Integer, _
ByVal itemId As String, _
ByVal filePath As String, _
ByVal fileDesc As DBString, _
ByVal fileType As String, _
ByVal lastModified As DBDateTime, _
ByVal fileSize As DBInt, _
ByVal author As DBString, _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal lastEditComment As DBString, _
ByRef modId As String _
)
'Usage
Dim sessionId As Integer
Dim itemId As String
Dim filePath As String
Dim fileDesc As DBString
Dim fileType As String
Dim lastModified As DBDateTime
Dim fileSize As DBInt
Dim author As DBString
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim modId As String
ItemFile.UpdateSpecific(sessionId, itemId, filePath, fileDesc, fileType, lastModified, fileSize, author, spare1, spare2, spare3, spare4, lastEditComment, modId)
public static void UpdateSpecific(
int sessionId,
string itemId,
string filePath,
DBString fileDesc,
string fileType,
DBDateTime lastModified,
DBInt fileSize,
DBString author,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString lastEditComment,
ref string modId
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- itemId
- Required. Holds the ID of the item to which the file belongs.
- filePath
- Required. Holds the path and file name of the file associated with the item.
- fileDesc
- Optional. Holds the description of the file.
- fileType
- Optional. This parameter is ignored. The file_type column in the Item_File table is obsolete. For the file_type column in ItemFile.GetAll() and GetByKey() returned datasets, the file extension from the filename in the file_path column will be returned.
- lastModified
- Optional. Holds the date/time of the last time the file was modified.
- fileSize
- Optional. Holds the size of the file in bytes.
- author
- Optional. Holds the name of the author of the file.
- 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
- Optional. Holds comments that describes why this record is being updated.
- modId
Required. Holds the modification ID assigned the last time this record was added or updated, for optimistic concurrency control. The passed value must match the record's modId for the record to be updated.
Output. Holds the new modification ID to identify this update of this record.
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.