MES Stateless API

Update Method (CertType)

Save PDF

Update Method (CertType)

Save PDF

Last UpdatedMar 17, 2026
4 minute read

The Update() method updates all columns for the specified certification type record in the Cert_Type table.

Syntax

'Declaration
 
Public Shared Sub Update( _
   ByVal sessionId As Integer, _
   ByVal certName As String, _
   ByVal maxLevel As Integer, _
   ByVal audit As Boolean, _
   ByVal duration As Integer, _
   ByVal hoursToRenew As Integer, _
   ByVal availToOperations As Boolean, _
   ByVal availToOperationSteps As Boolean, _
   ByVal availToProducingItems As Boolean, _
   ByVal availToConsumingItems As Boolean, _
   ByVal availToAttributes As Boolean, _
   ByVal availToGradeChange As Boolean, _
   ByVal availToStateChange As Boolean, _
   ByVal availToLogData As Boolean, _
   ByVal totalSignOffsRequired As DBInt, _
   ByVal requireSignOffComments As Boolean, _
   ByVal signoffNotes As DBString, _
   ByVal uptoExperimental As Boolean, _
   ByVal uptoApproved As Boolean, _
   ByVal uptoCertified As Boolean, _
   ByVal downToDisabled As Boolean, _
   ByVal downToExperimental As Boolean, _
   ByVal downToApproved As Boolean, _
   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 certName As String
Dim maxLevel As Integer
Dim audit As Boolean
Dim duration As Integer
Dim hoursToRenew As Integer
Dim availToOperations As Boolean
Dim availToOperationSteps As Boolean
Dim availToProducingItems As Boolean
Dim availToConsumingItems As Boolean
Dim availToAttributes As Boolean
Dim availToGradeChange As Boolean
Dim availToStateChange As Boolean
Dim availToLogData As Boolean
Dim totalSignOffsRequired As DBInt
Dim requireSignOffComments As Boolean
Dim signoffNotes As DBString
Dim uptoExperimental As Boolean
Dim uptoApproved As Boolean
Dim uptoCertified As Boolean
Dim downToDisabled As Boolean
Dim downToExperimental As Boolean
Dim downToApproved As Boolean
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
 
CertType.Update(sessionId, certName, maxLevel, audit, duration, hoursToRenew, availToOperations, availToOperationSteps, availToProducingItems, availToConsumingItems, availToAttributes, availToGradeChange, availToStateChange, availToLogData, totalSignOffsRequired, requireSignOffComments, signoffNotes, uptoExperimental, uptoApproved, uptoCertified, downToDisabled, downToExperimental, downToApproved, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)

public static void Update( 
   int sessionId,
   string certName,
   int maxLevel,
   bool audit,
   int duration,
   int hoursToRenew,
   bool availToOperations,
   bool availToOperationSteps,
   bool availToProducingItems,
   bool availToConsumingItems,
   bool availToAttributes,
   bool availToGradeChange,
   bool availToStateChange,
   bool availToLogData,
   DBInt totalSignOffsRequired,
   bool requireSignOffComments,
   DBString signoffNotes,
   bool uptoExperimental,
   bool uptoApproved,
   bool uptoCertified,
   bool downToDisabled,
   bool downToExperimental,
   bool downToApproved,
   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.

certName

Required. Holds the name of the certification.

maxLevel

Required. Holds the maximum level of the certification.

audit

Required. Holds a flag that indicates whether the certification requires an audit.

duration

Required. Holds the number of days the certification is valid (0 = permanent).

hoursToRenew

Required. Holds the number of hours of work required to retain the certification.

availToOperations

Required. Holds a flag that indicates whether the certification can be applied to operations.

availToOperationSteps

Required. Holds a flag that indicates whether the certification can be applied to operation steps.

availToProducingItems

Required. Holds a flag that indicates whether the certification can be applied to producing items.

availToConsumingItems

Required. Holds a flag that indicates whether the certification can be applied to consuming items.

availToAttributes

Required. Holds a flag that indicates whether the certification can be applied to editing attributes.

Note: Applying certifications to attributes is not currently supported.

availToGradeChange

Required. Holds a flag that indicates whether the certification can be applied to item grade changes.

Note: Applying certifications to item grade changes is not currently supported.

availToStateChange

Required. Holds a flag that indicates whether the certification can be applied to item state changes.

Note: Applying certifications to item state changes is not currently supported.

availToLogData

Required. Holds a flag that indicates whether the certification can be applied to logging data.

totalSignOffsRequired

Required. Holds the total number of sign-offs required.

requireSignOffComments

Required. Holds a value indicating whether sign-off comments are required.

signoffNotes

Required. Holds sign-off notes to show the user when signing off on this certification.

uptoExperimental

Required. Holds a flag that indicates whether the certification is needed to increase the status of a process to experimental.