Update(Int32,Int32,String,DBString,Int32,String,DateTime,DBDateTime,DBInt,DBString,DBInt,DBString,DBString,Int32,DBInt,DBInt,DBString,DBString,DBString,DBString,DBString,DateTime) Method
- Last UpdatedNov 06, 2025
- 3 minute read
The Update() method updates all columns of the specified specification record in the Qm_Spec table.
'Declaration
Public Overloads Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal qmSpecId As Integer, _
ByVal qmSpecName As String, _
ByVal qmSpecDesc As DBString, _
ByVal editLevel As Integer, _
ByVal verId As String, _
ByVal startEffLocal As Date, _
ByVal endEffLocal As DBDateTime, _
ByVal entId As DBInt, _
ByVal itemId As DBString, _
ByVal itemCategoryId As DBInt, _
ByVal processId As DBString, _
ByVal operId As DBString, _
ByVal categoryId As Integer, _
ByVal planId As DBInt, _
ByVal numberPointsPerPage As DBInt, _
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 qmSpecId As Integer
Dim qmSpecName As String
Dim qmSpecDesc As DBString
Dim editLevel As Integer
Dim verId As String
Dim startEffLocal As Date
Dim endEffLocal As DBDateTime
Dim entId As DBInt
Dim itemId As DBString
Dim itemCategoryId As DBInt
Dim processId As DBString
Dim operId As DBString
Dim categoryId As Integer
Dim planId As DBInt
Dim numberPointsPerPage As DBInt
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Date
QmSpec.Update(sessionId, qmSpecId, qmSpecName, qmSpecDesc, editLevel, verId, startEffLocal, endEffLocal, entId, itemId, itemCategoryId, processId, operId, categoryId, planId, numberPointsPerPage, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)
public static void Update(
int sessionId,
int qmSpecId,
string qmSpecName,
DBString qmSpecDesc,
int editLevel,
string verId,
DateTime startEffLocal,
DBDateTime endEffLocal,
DBInt entId,
DBString itemId,
DBInt itemCategoryId,
DBString processId,
DBString operId,
int categoryId,
DBInt planId,
DBInt numberPointsPerPage,
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.
- qmSpecId
- Required. Holds the ID of the specification.
- qmSpecName
- Required. Holds the name of the specification.
- qmSpecDesc
- Required. Holds the description of the specification.
- editLevel
- Required. Holds the privilege level required to edit this record.
- verId
- Required. Holds the version of this specification.
- startEffLocal
- Required. Holds the local time when this version of this specification becomes effective. The date and time are relative to the entity if ent_id is not null. Otherwise, it is relative to the middleware server.
- endEffLocal
- Required. Holds the local time when this version of this specification ceases to be effective. The date and time are relative to the entity if ent_id is not null. Otherwise, it is relative to the middleware server.
- entId
- Required. Holds the entity or the entity class to which this specification applies.
- itemId
- Required. Holds the item to which this specification applies.
- itemCategoryId
- Required. Holds the item category to which this specification applies.
- processId
- Required. Holds the process to which this specification applies.
- operId
- Required. Holds the operation to which this specification applies.
- categoryId
- Required. Holds the category to which this specification belongs.
- planId
- Required. Holds the default sample plan for this specification.
- numberPointsPerPage
- Required. Holds the number of samples per page for SPC Chart.
- spare1
- Required. Holds a value defined by language term 5157.
- spare2
- Required. Holds a value defined by language term 5158.
- spare3
- Required. Holds a value defined by language term 5159.
- spare4
- Required. Holds a value defined by language term 5160.
- lastEditComment
- Required. Holds the new comment that describes why this record is being updated.
- lastEditAt
- In/Out parameter. Holds datetime of when record was created or last changed.
A QM specification's display_seq column value determines the order in which the specification record appears in a dataset returned by a QM specification Get method. If two or more specifications in the dataset have the same order value (e.g., 2), then those specifications are ordered alphabetically within that order value's subgroup. Because the displaySeq parameter is not included in this overload of the Update() method, the display_seq column for specifications updated by this overload will have the default value of 1.
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 clear the existing value and enter an empty value, pass DB*.null (e.g., DBInt.null).