Update(Int32,Int32,Int32,String,String,Int32,Int32,Int32,DBInt,DBString,DBString,DBString,DBString,DBDouble,DBDouble,DBDouble,DBDouble,DBString,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 3 minute read
The Update() method updates all columns of the specified certification/item link record in the Cert_Item_Link table.
'Declaration
Public Overloads Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal keyId As Integer, _
ByVal keyType As Integer, _
ByVal category As String, _
ByVal valueName As String, _
ByVal triggerType As Integer, _
ByVal triggerPeriod As Integer, _
ByVal entriesRequired As Integer, _
ByVal displaySeq As DBInt, _
ByVal stringSpare1 As DBString, _
ByVal stringSpare2 As DBString, _
ByVal stringSpare3 As DBString, _
ByVal stringSpare4 As DBString, _
ByVal numberSpare1 As DBDouble, _
ByVal numberSpare2 As DBDouble, _
ByVal numberSpare3 As DBDouble, _
ByVal numberSpare4 As DBDouble, _
ByVal lastEditComment As DBString, _
ByRef lastEditAt As Nullable(Of Date) _
)
'Usage
Dim sessionId As Integer
Dim keyId As Integer
Dim keyType As Integer
Dim category As String
Dim valueName As String
Dim triggerType As Integer
Dim triggerPeriod As Integer
Dim entriesRequired As Integer
Dim displaySeq As DBInt
Dim stringSpare1 As DBString
Dim stringSpare2 As DBString
Dim stringSpare3 As DBString
Dim stringSpare4 As DBString
Dim numberSpare1 As DBDouble
Dim numberSpare2 As DBDouble
Dim numberSpare3 As DBDouble
Dim numberSpare4 As DBDouble
Dim lastEditComment As DBString
Dim lastEditAt As Nullable(Of Date)
DataEntrySched.Update(sessionId, keyId, keyType, category, valueName, triggerType, triggerPeriod, entriesRequired, displaySeq, stringSpare1, stringSpare2, stringSpare3, stringSpare4, numberSpare1, numberSpare2, numberSpare3, numberSpare4, lastEditComment, lastEditAt)
public static void Update(
int sessionId,
int keyId,
int keyType,
string category,
string valueName,
int triggerType,
int triggerPeriod,
int entriesRequired,
DBInt displaySeq,
DBString stringSpare1,
DBString stringSpare2,
DBString stringSpare3,
DBString stringSpare4,
DBDouble numberSpare1,
DBDouble numberSpare2,
DBDouble numberSpare3,
DBDouble numberSpare4,
DBString lastEditComment,
ref Nullable<DateTime> lastEditAt
)
Parameters
- sessionId
Required. Holds the session ID and thus the user who is making this method call.
- keyId
- Required. Holds the primary key or row_id value of a row for which data is being collected. This would be an entity ID if linked to an entity or a group ID if linked to a user group. For all others, it will be a row ID.
- keyType
- Required. Holds a number that represents the type of data collection being done (0=entity, 1=user group, 2=standard operation, 3=standard operation step, 4=operation, 5=operation step, 6=job, and 7=job step).
- category
- Required. Holds the category of the data collection (examples: "Yield KPI", "Defect Data", "Datalog Group"...).
- valueName
- Required. Holds the specific data or set of values to be collected within this category. (examples: "KPI 123", "Line 3 Defect Data", "Datalog Group ABC" ...).
- triggerType
- Required. Holds a number that represents the trigger mechanism for the data collection (0=shift start, 1=shift end, 3=daily, 4=weekly, 5=minutes).
- triggerPeriod
- Required. Holds the number of minutes between collection triggers if the trigger type is minutes (Default = 1).
- entriesRequired
- Required. Holds the number of entries required each time data collection is triggered. (Default = 1).
- displaySeq
- Required. Holds the number of the display sequence of this data entry schedule.
- stringSpare1
- Optional. Holds the contents of the user-defined spare1 field.
- stringSpare2
- Optional. Holds the contents of the user-defined spare2 field.
- stringSpare3
- Optional. Holds the contents of the user-defined spare3 field.
- stringSpare4
- Optional. Holds the contents of the user-defined spare4 field.
- numberSpare1
- Optional. Holds the contents of the user-defined numeric spare1 field.
- numberSpare2
- Optional. Holds the contents of the user-defined numeric spare2 field.
- numberSpare3
- Optional. Holds the contents of the user-defined numeric spare3 field.
- numberSpare4
- Optional. Holds the contents of the user-defined numeric spare4 field.
- lastEditComment
- Required. Holds comments that describes why this record is being added.
- 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.